This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Troubleshooting deadlocks

FormerMember over 7 years ago

Hello - new to Thwack, so pardon me if I am putting this question in the wrong place.... My company uses DPA (for SQL Server) for troubleshooting performance issues, and it works quite well - I am certain we don't use it to it's full potential in that area but it still has helped us tremendously. We are now faced with a sudden increase in deadlocks. Online researched has shown that DPA has some very good tools to help with deadlock resolution - but it does not appear that I have those tools available to me. Do I have an old version of the software? Is there a configuration change or module that needs to be installed for me to get these valuable tools? I am referring specifically to the reference found here:

Deadlock analysis in DPA - SolarWinds Worldwide, LLC. Help and Support

Regarding software version, I cannot even determine which version we have - how do I do this? And then how to I get that handy looking Deadlocks tab to show up on my trends page?

Thank you kindly, in advance!

Top Replies

0 m60freeman over 7 years ago

DPA has really good features in this area, but you have to be on 10.2 to get them. I think you also need to be monitoring a SQL 2012 or higher instance.
Cancel
Vote Up +2 Vote Down

Cancel

0 gcp over 7 years ago

jstafki wrote:

Regarding software version, I cannot even determine which version we have - how do I do this? And then how to I get that handy looking Deadlocks tab to show up on my trends page?
Thank you kindly, in advance!

The version number will be shown on the logon screen (bottom, right hand side of the panel), or if you are already logged on, go to the Options tab and you should have a version number on the top right hand side of the screen

0 FormerMember over 7 years ago in reply to m60freeman

I have discovered that you are correct.... the instance that I am working with is 2008 R2, and the deadlock tab does not appear! Aagghh!. Can anyone offer advice on how to track down deadlock information without Solarwinds?
Cancel
Vote Up 0 Vote Down

Cancel
0 jaminsql over 7 years ago in reply to FormerMember

There are trace flags and also the deadlock graph . DPA is using the extended event session information for deadlocks. This allows us to get this data and not be as much of a load as Profiler but, this method as mentioned isn't supported for 2008 R2.
Finding SQL Server Deadlocks Using Trace Flag 1222
Analyze Deadlocks with SQL Server Profiler
Gathering Deadlock Information with Deadlock Graph | Database Performance Tuning content from SQL Server Pro
Cancel
Vote Up 0 Vote Down

Cancel