Posted: 7/17/2012 7:07:38 AM
I just want to setup an automation to find out blocking in sql server and mail to the respective operator. I use here SQLSERVER: Locks (AVG Wait time) perf counter object, if this value goes above to 30000 then it will send me a message, here we got the mail and resolve the problem but the value of this perfmon counter is still shows greater then 30000, which is right. But the problem is if this values still remain greater then 30000, it will send me mails again and again. So can anyone know about how can we reset the value of this counter and is it safe to reset the value of counter.
Please suggest if there is another way to implement this without using Locks perfmon counter.
Thanks and Regards:
Posted: 8/20/2012 9:27:49 AM
I know I am late in replying but I have blogged on this website on WMI based realtime monitoring .You can search and go through it .If any doubts , let me know ..
Posted: 8/20/2012 11:34:53 AM
Actually, i have done this without using WMI.