I setup a SQL Advanced Metrics service for a MS SQL server but I get the following error:
Â
Â
Â
Â
Â
Service:Â SQL_Server SQL Advanced Metrics Service State: CRIT
Â
Output:Â – No stats for this instance
Â
When I go to the Agent and “Check Performance Counters” for SQL it returns “No data — 800007D5, no data to return” or just ‘0’.
Â
Is this Service Monitor expecting certain permissions? I don’t see permissions referenced in the online documentation.
Â