July 25, 2008 at 3:42 pm
I am trying to set up monitoring for locked processes using perfmon. Our monitoring system is able to read from csv files, so, I'm trying to use perfmon and the Wait Statistics(Cumulative wait time (ms) per second\Lock waits counter. But, when I set up this counter to execute, it only returns null values.
I am having issues with getting some of the sql server counters to return valid values. Some sql server counters work fine... I checked to ensure that the user for the Performance Logs and Alerts is a member of Performance Log Users. I don't have any issues on our testing server -- the only thing I can think of that is different is that our production environment has files on the SAN.
Any help would be appreciated!
July 26, 2008 at 11:29 am
Did you check permissions?
July 28, 2008 at 7:50 am
SQL ORACLE (7/26/2008)
Did you check permissions?
I checked to ensure that the user for the Performance Logs and Alerts is a member of Performance Log Users.
Are there other permissions I should be checking?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply