About Pricing Community Teams Start Free Trial

epmmis

asked on 7/12/2011

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

Last Comment

epmmis

8/22/2022 - Mon

Andrew Cliff

7/12/2011

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

ASKER CERTIFIED SOLUTION

louisreeves

7/12/2011

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

7/12/2011

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

7/14/2011

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

7/18/2011

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

Certified Expert Program

Credly Partnership

Udemy Partnership