Big Iron on Windows 2008 R2, Earning its Keep!

This screenshot goes in the category of “geek porn”…  It shows an IA64 system with 256 logical processors and 512GB of RAM, running at 72% CPU utilization. It is obviously running SQL Server 2008 R2 on Windows Server 2008 R2, since earlier versions of Windows Server and SQL Server are limited to 64 logical processors.

It is showing an interesting pattern of utilization by the individual processor cores, where many of them are working quite hard, while a few are idle. This probably means that processor affinity was set to limit the number of cores used by SQL Server 2008 R2.

This entry was posted in SQL Server 2008 R2. Bookmark the permalink.

One Response to Big Iron on Windows 2008 R2, Earning its Keep!

  1. Neil says:

    Nice image.. Maybe with this number of Processors some could be assigned affinty for I/O only – not sure of performance +/- impact, naturally depends on type of workloads it has.. but would be intrested to see how it was configured any trace flags used to force any conditions, what other kit it was connected to etc.. But now droolling all over my keyboard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s