Tweeted twitter.com/#!/StackDBAs/status/480708666841399296
3 added 55 characters in body
source | link

I have two servers running SQL Server.

  1. Server 1: MSSQL 2008 R2 Express (4 core)
  2. Server 2: MSSQL 2012 Developer Edition (8 core)
  • 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 Queryquery on SQL Server 2008 R2 Express itsit's showing 4 cores.

select scheduler_id, cpu_id, status, is_online  
from sys.dm_os_schedulers  
where status='VISIBLEstatus = 'VISIBLE ONLINE'

Am I using the right command to gauge the usage?

I have two servers running SQL Server.

  1. Server 1: MSSQL 2008 R2 Express (4 core)
  2. Server 2: MSSQL 2012 Developer Edition (8 core)

As far as I am aware 2008 Express should only use one core.

2012 Developer version should use all 8 cores.

However if I run the following command inside of SQL Query on 2008 Express its 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?

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?

2 edited tags
| link
    Post Migrated Here from stackoverflow.com
1
source | link

How can I tell how many Cores SQL Server is actually using?

I have two servers running SQL Server.

  1. Server 1: MSSQL 2008 R2 Express (4 core)
  2. Server 2: MSSQL 2012 Developer Edition (8 core)

As far as I am aware 2008 Express should only use one core.

2012 Developer version should use all 8 cores.

However if I run the following command inside of SQL Query on 2008 Express its 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?