Monitor and Server Health Group

One of the most frequent questions we get asked by server owners and users is "What's being monitored on my server?"  This has always been a a time consuming request, and one that I wished was easily answered.  Without having them go to the real time performance viewer and pull up a list of active metrics, there wasn't a stock report that answered the question.

I liberally stole the following query from the stored procedure named spMonitor_GetAvailableMetricsOnComputer.  What the query will produce is a report of all available metrics that apply to a server based on metric data gathered over the past two hours.  This will give you a very good idea of what is currently being monitored on that server.

SELECT  
 MetricName as "Metric Name",
 InstanceName as "Metric Instance Name",
 SourceName as "Monitoring Point"

FROM  
( 
 SELECT 
  Item.Name AS MetricName, 
  SourceGuid, 
  vComputer.Name AS SourceName, 
  MetricGuid,  
  InstanceName,  
  InstanceKey,  
  MonitorMetricLookup.MonitoringType + 0 as MonitoringType,  
  MonitorMetricLookup.DataType + 0 as ClassType, 
  ItemClass.ClassGuid as ClassGuid 
 
 FROM 
 ( 
  SELECT DISTINCT [MetricGuid], [SourceGuid], Instance AS [InstanceName], [InstanceKey] 
  FROM vMonitorAllMetricData 
  WHERE ResourceGuid = '%Computer%'  
  AND [TimeStamp] BETWEEN (select current_timestamp - (2.0/24.0)) AND (select current_timestamp)
 ) summary 
  
 INNER JOIN Item ON Item.Guid = summary.MetricGuid 
 INNER JOIN MonitorMetricLookup ON MonitorMetricLookup.Guid = summary.MetricGuid 
 INNER JOIN ItemClass ON ItemClass.Guid = summary.MetricGuid 
 LEFT JOIN vComputer ON vComputer.Guid = summary.SourceGuid 
) details 
 
ORDER BY

MetricName,
InstanceName,
SourceName

Now, all you have to do when asked that question, is point your users to the report that I've attached to this article, and let them answer the question themselves. 

Happy monitoring!