Menu
I am trying to resolve deadlocks. My Application gets deadlocks all the time when there is more then 10 users at the same time. I have tried with SQL profiler and can't figure it out.
The thing is, in SQL Profiler I have checked to use the Deadlock Graph Event. But when I run the trace the event never got logged. I can see there are many Deadlocks and Deadlock Chains, but none Deadlock Graph. Please advice. Thanks for help
207
Select the Events Selection tab. In the Events data column, expand the Locks event category, and then select the Deadlock graph check box. If the Locks event category isn't available, select the Show all events check box to display it. The Events Extraction Settings tab is added to the Trace Properties dialog box.
A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server. Using SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis.
On the Events Extraction Settings tab, select Save Deadlock XML Events Separately. In the Save As dialog box, enter the name of the file where you want to store the deadlock graph events. Select All Deadlock XML batches in a single file to save all deadlock graph events in a single XML file.
You need to have only Locks->Deadlock graph selected if you want to see Deadlock graph event only.
56
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
