Red Gate forums :: View topic - Receiving alerts about blocking/deadlocks too late
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Receiving alerts about blocking/deadlocks too late

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sql_guy75



Joined: 03 Apr 2014
Posts: 3

PostPosted: Thu Apr 03, 2014 12:54 pm    Post subject: Receiving alerts about blocking/deadlocks too late Reply with quote

We had a blocking occurred in our environment supposedly around 11:11 AM yesterday on 4/2/2014. However, within the alert inbox, we do not see that there is a blocking occurring, not until at 2:00 am the next day on 4/2 2:00, which it then starting reporting it, because another process tried to access the SQL resources.

I can see that there is a long query reported at 11:13, but supposedly it ended since it reported the completed duration.

The first alert I received, which was around 2:00 AM is when the import process runs. The alert indicates that blocking process/query started at 11:11 am on 2 Apr 2014.

I would nice to be alerted of this symptom before it becomes a problem, as it did last night.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6668

PostPosted: Fri Apr 04, 2014 1:25 pm    Post subject: Reply with quote

Can you copy/paste the alert details? It seems odd to me that you have a process that runs at 2, then you get a blocked process alert right away, but the alert says it started at 11:13.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group