Receiving alerts about blocking/deadlocks too late

sql_guy75sql_guy75 Posts: 5
edited April 4, 2014 8:25AM in SQL Monitor Previous Versions
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.