I am working on a installation of SCOM, monitoring some SQL Servers. However, I am having an issue collecting the performance counters.
In particular, in SCOM it is showing that the Page Life Expectancy is 0 for all of my SQL Server, when in fact is above 20,000 on most of the servers.
I can't see anything in the SCOM Logs to suggest why this is happening. Any suggestions as to the possible cause, or places to look for more information will be greatly appreciated.
James