Blocked SQL Process - configuration based on SQL keywords

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Blocked SQL Process - configuration based on SQL keywords

Postby simonspring » Fri Jan 15, 2010 9:49 am


In a future release of SQL Response it would be good if "Blocked SQL process" alerts were configurable down to keywords within the SQL of the blocked and/or blocking process. Microsoft Reporting Services has a regular process that is blocked. The stored procedure CheckSessionLock is regularly blocked by WriteLockSession. Microsoft say this is expected behaviour

I do not want to be alerted to these blocks but I do want to be alerted to all others.

I wasn't sure if this was already covered by the post but thought it worth raising as for me (and probably anyone else running reporting services) the feature is not very usable at present with all its false alarms.

Posts: 5
Joined: Tue Dec 01, 2009 9:01 am

Postby peter.peart » Mon Jan 18, 2010 2:18 pm

Hi Simon,

I believe it does relate to this issue, and have added your comments accordingly.

I also believe that this is on the cards for V2 of the product, which should be out later this year. If you would like to get involved with usability sessions for V2, and also put your ideas forward, you can e-mail thefutureofmonitoring(at) and you will be adedd to the list.

Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Site Admin
Posts: 362
Joined: Tue Sep 02, 2008 8:58 am
Location: Top floor, RG towers with the cool kids

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests