If the SQL collector continues to collect unprocessed data, which appears as zeros on reports, after three polling cycles, follow these instructions.
- Log in into the SQL server.
- Execute the
SELECT MAX(vPR.DateTime) AS LatestDateTime FROM Perf.vPerfRaw AS vPRquery to display the last date and time in which data was written to the database.
- If this is not a realtime value, check the Microsoft System Center Operation Manager for issues.