SQL Server Performance Forum – Threads Archive

CPU upgrade help

I need some help with adding another CPU to my W2k SQL2000 server –
I initially installed with 2 CPU’s and licensed per CPU, what has
to be done to upgrade my server with another CPU is it just a case
of updating my Microsoft license or do I have to actually do something
to the server from the licensing side?
Will SQL automatically see and start using the new CPU?
I dont recall having to specifically specify the processor quantity when
I did the install but then it was a long time ago!![:I] Thanks
Geoff

Ensure the licenses are purchased and once the 2 processors are installed, startup SQL Server services and edit to takeon from server properties. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I dont understand this
QUOTE "and edit to takeon from server properties."
What do I have to edit ?
Server currently has 2 processors and I want to add 1 (or 2)
more, how will the server know it is licensed for 2 more
processors.
I dont want to add a processor and find that SQL no longer
works because of a potential license issue. Purchasing the licenses is not the issue I have it is more
a making sure the server comes back up and uses the extra processors Has anybody actually done this procedure? Thanks

In BOL words:By default, all available processors are used.
How to configure the number of processors available for parallel queries (Enterprise Manager)
To configure the number of processors available for parallel queries Expand a server group.
Right-click a server, and then click Properties.
Click the Processor tab.
Under Parallelism, select the number of processors to execute queries in parallel.
By default, all available processors are used. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>