With SQL Server should I get more processors or faster processors?

A. With SQL 6.5 and below a single query will only ever use a single processor, whereas in SQL 7 it will parellise queries if it thinks that will make it run faster.

Usually processor isn't the bottleneck on SQL systems - it is usually the disk subsystem. But as a rule of thumb if you have few users/processes then go for faster processors, and if you have lots of users then go for more processors.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish