Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Four CPU's and SQLServer 7.0 (or 8.0) - performance?

Status
Not open for further replies.

BootMeUp

MIS
May 31, 2000
35
US
Has anyone done or read of benchmarks on SQL7/8 use of four processors in executing queries? Are four twice as fast as two?
 
That is a hard one to answer...

If your SQL uses 20% of the performance of 2 CPU's when doing heavy queries. Then I guess that 4 processors wouldnt make too much of a difference. It would only really apply when the processors are overloaded and need to loadbalance with others. Thats when the speeds will come te be seen...

Hope this helps you out a little

regards

AdrianNL
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top