Determining the no of processor cores in your SQL Server - SQLServerCentral

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Get Your Own Blog

If you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com.

Contact the author

Please log in or register to contact the author of this blog

All Blogs

All Bloggers on SQL Server Central

Feeds

Subscribe to this blog

Archives for this blog

DatabaseExpertise.com

Determining the no of processor cores in your SQL Server

Posted on 31 August 2010
Comments
Briefcase
Print

SELECT cpu_count/hyperthread_ratio AS cores

   FROM sys.dm_os_sys_info;

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.