Avatar of epmmis
epmmis
 asked on

Using /3GB and /USERVA switchs with SQL 2005

SQL 2005 w/sp2 on Windows 2003 sp2 32b Standard Edition server, will using the /3GB and/or the /USERVA switches enhance SQL 2005's performance?
Microsoft SQL Server 2005Windows Server 2003Microsoft SQL Server

Avatar of undefined
Last Comment
epmmis

8/22/2022 - Mon
Andrew Cliff

Regarding the 3GB switch, SQL 2005 STD will use whatever the OS can see, so yes to that one.
ASKER CERTIFIED SOLUTION
louisreeves

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Andrew Cliff

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Aaron Shilo

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
epmmis

ASKER
Thanks all.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck