If the SQL collector continues to collect unprocessed data, which appears as zeros on reports, after three polling cycles, follow these instructions.


  1. Log in into the SQL server.
  2. Execute the SELECT MAX(vPR.DateTime) AS LatestDateTime FROM Perf.vPerfRaw AS vPR query to display the last date and time in which data was written to the database.
  3. If this is not a realtime value, check the Microsoft System Center Operation Manager for issues.