November 3, 2016 at 6:12 am
As I need to collect the deadlock report with the details Start/End time, Table/Index name,Username ,Statement (process and victim)and Frequency if they are identical deadlocks. can any one assit me in getting this . I have a script which provides the XML information but I would like to prepare the report in the said columns .
November 7, 2016 at 11:39 pm
This was removed by the editor as SPAM
November 14, 2016 at 7:13 am
Have a look at trace flags 1200, 1204 and 1222. For your post you will find them extremely useful....
November 16, 2016 at 12:26 am
Here is an exhaustive article about your question:
https://www.brentozar.com/archive/2014/03/extended-events-doesnt-hard/
Actually you can create XE-session and open live data view when locks or deadlocks appear.
December 22, 2016 at 7:49 am
If you are lucky enough,we can now get deadlock information from system health session without any additional tracing .Have a look at below great article :
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply