Posted inSQL
Microsoft
5 years ago
Create a new DMV that Exposes CPU Utilization Information
One common way to get CPU utilization by SQL Server is to query the sys.dmosringbuffers DMV. This DMV is undocumented and unsupported. It also sometimes returns incorrect information (with negative values or values over 100%) on some systems. This usually happens on systems that have more than 64 cores). I have attached a sample query that uses sys.dmosringbuffers for this purpose.
Archived
Storage EngineSuggestionsArchived
Vote
0 Comments