Metrics missing from SQL Server instance overview and reports (4305965)

Multiple metrics are missing from the SQL Server instance overview and Executive Summary Report:

• Both database and on-demand data connection tests from the databases global administration are successful.
• Metrics are missing from the SQL Server instance overview; for example: Throughput  (Logons, Executions) and SQL Server Instance Memory Usage.
• Metrics are missing from the SQL Server Executive Summary Report; for example: Total SQL Server Memory and Cache Hit Ratio.

The following SQL query can be used to verify the availability of the performance counters:

SELECT COUNT(*) FROM sys.dm_os_performance_counters;

If the return value is 0 rows, it means that the performance counters have been either disabled or not working as expected. Additional information can be found on the following article from Microsoft: sys.dm_os_performance_counters (Transact-SQL).

The following collections may be affected by the missing SQL Server Performance Counters (empty "sys.dm_os_performance_counters" table):

• DBSS_Access_Methods
• DBSS_Buffer_Manager
• DBSS_Cache_Manager
• DBSS_Database_Info
• DBSS_Database_Mirroring_Performance_Counters
• DBSS_Latches_Locks
• DBSS_Lock_Statistics
• DBSS_Memory_Manager
• DBSS_Plan_Cache_
• DBSS_SQL_Server_Load
• DBSS_Statistics
• DBSS_Tempdb_Version_Store
• DBSS_Top1000_dm_Exec_Query_Stats_Entries