Networks

Ask something
Discussion Locked

dual vs triple processing

0 helpful
3 replies

by dlmacd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Our company has recently been employed to assist a local casino in the management of a new data system or slots management system.
Server specs from the vendor call for 3 x 600 Mhz processors on the server running SQL 7.0 and 2000. The reason givenwas that SQL will "grab" two processors.
We feel 2 x 1.26 Ghz would be a more economical solution and have not heard of SQL allocating processors.
Does anyone have experience in this area?
Thanks

3 replies

by timthetoolman

Hi,

SQLServer2000 Enterprise edition can be configured to use a set number of processors in an MP system. You could set it to use one only...

Do the vendors specify xeon processors? They have much more L1 cache and can out perform much faster CPUs under certain circumstances.

The risk you run when changing the recommended configuration is that if you DO have performance problems, the vendors will turn around and say "I told you so" even if it is TRUELY a problem with their software.Hope this helps,
Cheers,
Tim.

This discussion is closed to new replies.