Why aren't deadlocks showing up in history?

randyvrandyv Posts: 166
edited September 28, 2009 2:44PM in SQL Monitor Previous Versions
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?

What we do in life echoes in eternity <><
Randy Volters


  • Options
    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?

    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.