• Adam Thurgar

CPU schedulers offline

Whilst doing a pre-production health check on a SQL Server 2016 Standard Edition server I noticed that some cpu schedulers were offline.

I ran the following query against the DMV sys.dm_os_schedulers.

SELECT * FROM sys.dm_os_schedulers;

This showed that 4 where online and 4 offline.

So SQL Server was only using 4 of the 8 schedulers.

Checking the SQL Server licensing for Standard Edition - “Limited to lesser of 4 sockets or 24 cores”.

I raised this with the infrastructure engineer who found out that the default setting in VMware is to assign all vCPUs as sockets instead of cores. So they adjusted the cores/sockets on this VM to be 1 socket with 8 cores and now SQL Server is using all the available schedulers.

11 views0 comments

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