http://blogs.msdn.com/buckwoody/archive/2007/08/13/script-of-the-day-find-the-cores-on-a-system.aspxSure, you can get the number of processors fairly easily ffrom SQL Server. But did you know you can also get the number of actual cores as well? This little gem works with SQL Server 2005: SELECT cpu_count/hyperthread_ratio AS sockets FROM sys.dm_os_sys_info;en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/buckwoody/archive/2007/08/13/script-of-the-day-find-the-cores-on-a-system.aspx#4378166Tue, 14 Aug 2007 07:15:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:4378166MSDN Blog Postings » Script of the Day - Find the Cores on a System<p>PingBack from <a rel="nofollow" target="_new" href="http://msdnrss.thecoderblogs.com/2007/08/14/script-of-the-day-find-the-cores-on-a-system/">http://msdnrss.thecoderblogs.com/2007/08/14/script-of-the-day-find-the-cores-on-a-system/</a></p>http://blogs.msdn.com/buckwoody/archive/2007/08/13/script-of-the-day-find-the-cores-on-a-system.aspx#4378171Tue, 14 Aug 2007 07:15:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:4378171MSDN Blog Postings » Script of the Day - Find the Cores on a System<p>PingBack from <a rel="nofollow" target="_new" href="http://msdnrss.thecoderblogs.com/2007/08/14/script-of-the-day-find-the-cores-on-a-system/">http://msdnrss.thecoderblogs.com/2007/08/14/script-of-the-day-find-the-cores-on-a-system/</a></p>http://blogs.msdn.com/buckwoody/archive/2007/08/13/script-of-the-day-find-the-cores-on-a-system.aspx#6708673Sun, 09 Dec 2007 02:56:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:6708673Kalen Delaney<p>In almost all my classes, and every time I do any performance consulting, I get the question &quot;How can</p> http://blogs.msdn.com/buckwoody/archive/2007/08/13/script-of-the-day-find-the-cores-on-a-system.aspx#6708731Sun, 09 Dec 2007 03:09:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:6708731Kalen Delaney<p>In almost all my classes, and every time I do any performance consulting, I get the question &quot;How can</p>