Red Gate forums :: View topic - Why aren't deadlocks showing up in history?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Why aren't deadlocks showing up in history?

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
randyv



Joined: 28 Feb 2007
Posts: 113

PostPosted: Fri Sep 25, 2009 3:44 pm    Post subject: Why aren't deadlocks showing up in history? Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Mon Sep 28, 2009 7:44 pm    Post subject: Reply with quote

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
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