Over the years, I've heard people mention that they wanted a way to determine the physical processor configuration on a machine, for example, how many cores are on the server, is hyperthreading enabled, etc.
The good news is that uber-genius of the SQL Server engine, Slava Oks, has published a blog entry on this a while back with a reference to several utilities which will give you this information. You can find Slava's blog entry on this here:
I encourage you to make this a part of your reading!
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.