SQL Server : Logical CPU Count

Scheduler is a component of SQLOS which evenly distributes load amongst CPUs.

scheduler_id – ID of the scheduler. All schedulers that are used to run regular queries have ID numbers less than 1048576. Those schedulers that have IDs greater than or equal to 1048576 are used internally by SQL Server, such as the dedicated administrator connection scheduler.

SELECT  cpu_count / hyperthread_ratio AS physical_cpu_sockets

FROM    sys.dm_os_sys_info ;

SELECT  cpu_count FROM    sys.dm_os_sys_info ;

SELECT  hyperthread_ratio FROM    sys.dm_os_sys_info ;

SELECT  * FROM    sys.dm_os_sys_info ;

Brgds,

Chhavinath Mishra

Sr. Database Administrator

Microsoft Certified IT Professional (MCITP)