Support for 256 logical processors in SQL Server 2008 R2.

Windows server 2008 R2 Datacentre Edition along with SQL Server 2008 R2 enables you to scale up to 256 logical processors (This is a big improvement over the previous maximum of 64 processors). Which showing in the following snapshot with 64 quad-core CPUs (which gives you 256 cores).

So now you can run your multiple SQL Server tasks in parallel up to 258 (number of Cores +2) tasks very easily and achieve the good parallelism.


About Zaim Raza

7 Years of professional experience in Business intelligence using SQL Server and Microsoft SharePoint/.net Technologies. Experience in Data warehousing, Data Modeling, Data profiling, Data Integration, Data cleansing, consultations and enterprise reporting. I want to work for organization where I am able to utilize my skills, experience and knowledge to transform the technology into business value.
This entry was posted in SQL Server features. Bookmark the permalink.

Leave a Reply

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

You are commenting using your 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