Thinking outside the box

Patron Saint of Lost Yaks

posts - 200, comments - 701, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

<< An alternative to IDENTITY column | Home | Strange happening >>

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

Related Links

Competition (2/28/2009)
Proper Relational Division With Sets (7/2/2010)
A tale from a Stalker (4/27/2011)
Index pages (4/30/2008)
Change collation (8/19/2009)

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

Feedback

No comments posted yet.

Post Comment

Title
Name
Email
Url
Comment
Remember Me?
Enter the code shown above:

Powered by:

Copyright © Peter Larsson