SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

A DBA’s Fantasy

I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs (which gives you 256 cores). This requires Windows Server 2008 R2 Datacenter Edition, along with SQL Server 2008 R2.  As Microsoft puts it:

“SQL Server 2008 R2 helps you take advantage of the latest hardware technology advancements and enables high scalability building on top of industry-standard hardware for great total cost of ownership. Microsoft Windows Server 2008 R2 and SQL Server 2008 R2 working in concert enable customers to scale up to 256 logical processors.”

Who says Windows (and SQL Server 2008 R2) cannot do big iron?


That sort of makes my test system look pathetic…


Technorati Tags:


Posted by Charles Tsang on 12 October 2009

Woah, just noticed that all the CPUs are all at 90% usage or more... So exactly what was happening on the box??

Posted by Jerry Sommerville on 12 October 2009

We've been doing big iron with more than 1700 online users for 3 years now. We use an Itanium processor with 48 logical CPUs.  The trick is good code to keep the locking down to a minimum, not to say we have good code.  We don't, thus we are constantly monitoring the system to combat that issue.  Bottom line though is that Windows will do big iron apps.

Posted by Disel-1152013 on 12 October 2009

we hv itanium server here as well with 16 CPUs and 14gb ram but we r still working on good code for lockings... any pointers u can share?

Posted by sheerich on 12 October 2009


It appears that the machine has "a stress test in progress".

Posted by Marc Brooks on 13 October 2009

They're busing looking for the Danger/Sidekick data.

Leave a Comment

Please register or log in to leave a comment.