Someone in our group raised the question of whether or not SQL Server 2000
Standard Edition can make use of dual CPU's. Please tell me that it does?

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

Yes it does. If Windows can see both processors SQL Server will see it.

Within Enterprise Manager right-click on the server name and choose
properties.
Check the processor tab -- you can specify which processors it uses.

--
Keith


"Mike Labosh" <mlabosh_remove_ (AT) hotmail (DOT) com> wrote

Standard Edition can handle up to 4 CPU's.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com


"Mike Labosh" <mlabosh_remove_ (AT) hotmail (DOT) com> wrote

Someone in our group raised the question of whether or not SQL Server 2000
Standard Edition can make use of dual CPU's. Please tell me that it does?

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

Cool, thanks!
--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~