Amazon RDS for SQL Server | Wait Events Drilldown
<Unknown> entries in the All Workload | Database tree and SQL not available entries in the All Workload | Statement tree may mean:
- SQL Server did not add the metric to the event. Perhaps the metric was too difficult to get or the metric was no longer available.
- The event was created by a process that does not have that metric. Typically these are internal SQL Server processes.
Amazon RDS for SQL Server performance counters
When Amazon RDS for SQL Server performance counters are missing, Spotlight will not be able to collect the data it requires, and will display “0” for many of its components. Most obvious will be the Memory icons on the Amazon RDS for SQL Server | Overview page, which will show 0 MB of memory used by Amazon RDS for SQL Server. Also, many of the flows on the Overview page will show no activity, and many drilldowns will show incomplete information.
Spotlight Enterprise uses sys.dm_os_performance_counters to retrieve data for many of its displays. In some rare cases, this table may not contain information.
When Amazon RDS for SQL Server performance counters are missing, Spotlight will not be able to collect the data it requires, and will display “0” for many of its components. Most obvious will be the Memory icons on the Amazon RDS for SQL Server | Overview page, which will show 0 MB of memory used by Amazon RDS for SQL Server. Also, many of the flows on the Spotlight Overview page will show no activity, and many drilldowns will show incomplete information.
Spotlight Enterprise raises the Missing SQL Performance Counters Alarm shortly after connecting if it detects that the sysperfinfo or sys.dm_os_performance_counters table contains no data.
Verify the sys.dm_os_performance_counters table contains no data
Run the following SQL in the appropriate version of Amazon RDS for SQL Server Management Studio for Amazon RDS for SQL Server. If this query returns no records, then your SQL Server performance counters are missing. Spotlight Enterprise will not be able to operate correctly.
select * from sys.dm_os_performance_counters
More information
Open the SQL Server Knowledge Base at http://msdn.microsoft.com.