July 25, 2008 at 9:18 am
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 29, 2008 at 8:53 am
I'm not sure why you'd want to do this through perfmon, the dmvs are much better for this sort of thing.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
July 29, 2008 at 9:28 am
colin Leversuch-Roberts (7/29/2008)
I'm not sure why you'd want to do this through perfmon, the dmvs are much better for this sort of thing.
Colin, thanks for your response. So, would setting up a job that run every minute against sys.dm_os_performance_counters and just out put to a text file be what you had in mind? I would have liked to query more often than 1 minute, but it appears the most frequent allowed when setting up a jobs is 1 mintue.
Or, did you have something else in mind?
It was easier for me to use perfmon because the counters were there and the 3rd party system we use for monitoring was used to reading those files...that is no longer working.
July 29, 2008 at 12:15 pm
I do much as you say, http://sqlblogcasts.com/blogs/grumpyolddba/default.aspx and select trending for details,
I have changed code and such for 2005 and there's some stuff on my web site too http://www.grumpyolddba.co.uk ( I will write up the newer code soon )
contact me off there if you want more code examples. I do collect perfmon counters too, from perfmon, but I put them into a database table.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply