I got SQLServer performance counter with AppMon 7.0 Hostagent. However, some values can not be obtained.
[SQLServer: Batch Requests / sec] OK
[SQLServer: Buffer Manager \ Page life expectancy] NG
In the error message,
SQLServer: Buffer Manager
Page life expectancy
all instances: Unable to get Value (Object: SQLServer: Buffer Manager, Instance: (null), Counter: Page life expectancy).
Detailed error message: Ea- # (System error code: 0x3E5
I want to know the cause and solution of this error.
The error you're getting (0x3E5) is an error coming back from SQLServer which indicates an overlapping IO Operation in progress.
I would just rerun and see if this same error is report repetitively. I thought this was just more a status to indicate two IO operations were running at the same time, which itself isn't a problem. However I'm not a SQLServer expert so this could be wrong.
If it consistently happens with the same metric, perhaps you should remove that metric and see if the problem persists.
Thank you for your comment.
The failing metrics are the same each time. I did some tests. The following items can obtain data.
The following items occur when an error occurs in data acquisition.All error codes are 0x3E5