Need to bung an additional CPU into our SQL2000 server, anyone know what's involved SQL side doing this?

Thanks

John

 

What OS are you running ?

I take it Win2k, if so bung the processor in, turn server back on, make sure the OS can see the 2nd CPU, under Devices in Computer Management

If not, you will have to change the kernel to Multiprocessor, but thats easy cos you only update the driver for the single CPU one

Then AFAIK you just go into SQL Admin, right click on the SQL Server object, select properties, then tell it to use 2 CPU's

S

 

then go pay MS for the extra processor license

 

Not if it's licensed on a CAL basis

 

CAL = Client Access Licence. Unfortunately nothing to do with the Server software... SQL is licenced on the number of CPU's... adding a 2nd is expensive.

 

You can license SQL by CPU OR CAL's the choice is yours