Receiving alerts about blocking/deadlocks too late

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

Receiving alerts about blocking/deadlocks too late

Postby sql_guy75 » Thu Apr 03, 2014 11:54 am

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.
Posts: 3
Joined: Thu Apr 03, 2014 11:35 am

Postby Brian Donahue » Fri Apr 04, 2014 12:25 pm

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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests