November 12, 2003 at 2:44 pm
I know SQL Server 7.0 supports >4 CPU with Enterprise Edition. I rememeber reading an article how the additional CPU's where not utilized in a linear fashion. Anyone have any good articles to support this?
merlin11968
November 12, 2003 at 3:54 pm
With any application, the scalability curve's slope decreases as processors are added: going from two processors to four processors might increase performance by 50% and going from four processors to eight would only increase performance by another 50% (this would be a logarithmic curve).
Database systems in general (and SQL Server specifically) will actually have more linear curves (i.e. better scalability) than most other uses if they are supporting many concurrent users. SQL Server is actually optimized for the TPC benchmarks which reward this scalability. Older Intel processors typically have a flatter scalability curve (but always poorer net performance) because memory speed has not kept up with processor speed. Windows 2000 Server has a flatter scalability curve than does NT 4. Considering where you work, you might want to peruse some of the Redbooks, e.g.:Tuning IBM eServers xSeries Servers for Performance.
--Jonathan
--Jonathan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply