Forum Discussion

joshlowit1's avatar
5 years ago

SQL showing No Data

Hi Team, I have a couple of collectors that are showing No Data for SQL Server. Now the SQL servers do not get used a lot as they are in a test environment, would that cause the collector to ...
  • Mike_Moniz's avatar
    5 years ago

    So WinSQLServer- DataSource doesn't use WMI but uses PERFMON. Looking at the bottom of the screenshots you can see it got "NaN" for several items. I can't speak for SQL directly but many times when I see perfmon issues in windows, it usually due to the counters missing on the system itself and that you need to repair them. I would google something like "perfmon mssql counters missing" and try reviewing some of the items listed there.