mega_stream

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

Thanks

John

*Sonic*

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

Puff The Magic Wagon!

iTrader: (2)

then go pay MS for the extra processor license

ChrisB

Not if it's licensed on a CAL basis

Kieran_Burns

iTrader: (1)

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.

*Sonic*

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