• Adam Thurgar

Schedulers offline

Whilst working with a number of SQL Server Standard edition installations I noticed that some schedulers were offline.

This can be a common problem with your VM configuration assigning the vCPUs as sockets instead of cores.

This is only applicable in Standard Edition.

So you may assign 8 sockets - but only 4 will be used. but if you assigned 8 cores, then all of them should be used.

The more vCPUs the better.

Check the SQL Server licensing for Std Edn - “Limited to lesser of 4 sockets or 24 cores”


You need a good understanding of the definitions of sockets and cores as defined by Microsoft (not easy).


You can use the following query to check for offline schedulers:

SELECT * FROM sys.dm_os_schedulers WHERE is_online = 0;


Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t