All geek questions in one place

History of Dead Castles

How can we get information about the past history of dead locks. For example, today at 10 am. thank you

+4
source share
1 answer

Edit:

I stand, corrected @ Martin Smith. Refer to his link on how to use SQL Server advanced events to view requested historical deadlock graphs. It looks like it was added in SQL 2008. Learn something every day.

Original:

SQL Server does not have a reserve for viewing past deadlocks. You must start an active trace with the trace flags set. The link Robert Harvey mentioned above is a great place to start. You can also use SQL Server Profiler and specify the event type Locks-> Deadlock Graph and make sure that the TextData column TextData specified to get a different view of the deadlock graph. I personally find Profiler tracing easier.

+3
source

Source: https://habr.com/ru/post/1391949/

More articles:


All Articles