I have two servers running SQL Server.
- Server 1: SQL Server 2008 R2 Express (4 core)
- Server 2: SQL Server 2012 Developer Edition (8 core)
As far as I am aware SQL Server 2008 R2 Express should only use one core.
SQL Server 2012 Developer version should use all 8 cores.
However if I run the following command inside of SQL query on SQL Server 2008 R2 Express it's showing 4 cores.
select scheduler_id, cpu_id, status, is_online from sys.dm_os_schedulers where status = 'VISIBLE ONLINE'
Am I using the right command to gauge the usage?