We have noticed an odd issue on two servers in a 3 node SQL Server 2017 cluster running Always On Availability Groups. When checking the DMV sys.dm_os_performance_counters the row counts are totally out showing 4billion+ rows.

Has anyone else experienced this?

The code I am running is

SELECT * FROM sys.dm_os_performance_counters

execution plan properties

estimated execution plan

  • Is this causing any issue? The query plan doesn't look like the poor estimate caused a bad plan. 2 days ago
  • Hi David It can cause bad plans if we join this DMV with others. It does seem to correct itself after a reboot, its more a peculiarity and if anyone else had seen it
    – Stockburn
    2 days ago
  • How many instances do you have on the same server? How many PerfMon counters are there? Try running this powershell on a server (Get-Counter -ListSet * | % {$_.counter}).Count
    – Zikato
    2 days ago
  • 2
    Just out of curiosity, what other DMV would you join perf counters to?
    – Paul White
    2 days ago


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.