All Categories

  • How to Find Deadlock Information from SQL Server

    2/2/2014 -
    There're many way to find sql server deadlock or resolve the issue. At this blog, I will show how to use SQL Server Profiler to show deadlock or one example how to fix it. Find deadlock information from sql server Open SQL Server Profiler Create new Trace file At General Tab check Save to file, and save file to shared folder. This is because after stop trace, you can analytic the trace log information. At Events Selection tab, expend Locks and check "Deadlock graph". Trace Properties will show "Events Extraction Settings" tab, then click "Save Deadlock XML events separately" and save file to shared folder. Click "run"  If you know where the application cause the dead lock then go to the application and re cause the error. Stop the trace. Go to the trace file you saved to shared folder, and search "dead", you should find the deadlock xml.