Unused CPUs

Comments are closed
How can we help?
< All Topics
Print

Unused CPUs

Servers can have CPUs assigned, that are not available to SQL Server. Unused CPUs are still fully licensed, so unused CPUs should not exist.

See the following article for details: https://www.mssqltips.com/sqlservertip/4801/sql-server-does-not-use-all-assigned-cpus-on-vm/

To query the Performance Store database for servers with unused CPUs, use:

select s.*
from dbo.v_servers s
where s.unused_cpu_count > 0

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents