Why aren't deadlocks showing up in history?

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

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

Why aren't deadlocks showing up in history?

Postby randyv » Fri Sep 25, 2009 3:44 pm

Hello -

I thought I was being told that on average there is one deadlock in the morning on my server. However, due to some performance complaints, I started going back using the history view and find that SQL Performance doesn't really keep history of deadlocks?

Why is this the case? Once the information is captured, I would think it can be recalled just like anything else. Or, do I have something misconfigured?

Suggestions?
What we do in life echoes in eternity <><
Randy Volters
randyv
 
Posts: 113
Joined: Wed Feb 28, 2007 3:27 pm

Postby Matthew Flatt » Mon Sep 28, 2009 7:44 pm

Hi Randy,

I am a little unsure about the issue, is it that SQL Response hasn't kept details about previous deadlocks or that some details are missing? On the top right of the SQL Response GUI, you can filter the information being shown. Do you have a filter set at all?

Also there are options to purge alert files after a specified period of time, can you verify that you are not also using this option and looking for details on an older deadlock which has been purged?

Thanks,
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests