DEADLOCKS in SQL DB

[Elena_Rabinovic]

Hi

We are having a severe issue with DEADLOCKS on our SQL DB .

I mean DEADLOCKS of Data Base itself and not the application.  

what is the way to investigate it with AppDynamics ? Any suggestion or reference to any source of information on this theme will help. Thank you! 

[iamryan]

Hi @Elena.Rabinovich,

I found this AppD Knowledge Article: What errors indicate potential database corruption? 

Please check it out and let me know if it was able to help you out.

[Elena_Rabinovic]

Thank you for the response but the article is not exactly relevant since I am looking for information on all the DEAD Locks actually happened in our MS  SQL DB (not MYSQL DB) during particular period of time.

And what is needed is to see in APP Dynamics the list and the details of all the happened Deadlocks in order to investigate the mutually locked resources and its reason.

Thank you!

[iamryan]

Hi @Elena.Rabinovich,

Thank you for letting me know. Let's see if the Community can jump in and provide additional help. If you also happen to find any answer, please come back and share that as a reply to your post.