buck.woody
LinkedIn | FaceBook | Twitter
Resume
Sure, 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;GO
PingBack from http://msdnrss.thecoderblogs.com/2007/08/14/script-of-the-day-find-the-cores-on-a-system/
In almost all my classes, and every time I do any performance consulting, I get the question "How can
Professional Blog
Personal Blog
Podcasts
Articles
University of Washington