Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

How many logical and physical processors do you have?

SELECT cpu_count AS [Logical CPUs], 
       cpu_count / hyperthread_ratio AS [Physical CPUs]
FROM   sys.dm_os_sys_info

Print | posted on Tuesday, December 02, 2008 5:08 PM | Filed Under [ SQL Server 2008 Administration SQL Server 2005 ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET