Blocked SQL Process - configuration based on SQL keywords

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

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Blocked SQL Process - configuration based on SQL keywords

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

Hi,

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 http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/290aa503-03c2-415b-bc30-59422ccb3bb2.

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 http://www.red-gate.com/messageboard/viewtopic.php?t=8157&highlight=blocked+sql+process 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.

Thanks,
Simon
simonspring
 
Posts: 5
Joined: Tue Dec 01, 2009 10:01 am

Postby peter.peart » Mon Jan 18, 2010 3: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)red-gate.com and you will be adedd to the list.

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


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests