We can use the default system_health extended event to obtain the deadlock details. We can enable the trace flags 12 to capture deadlock detail information in an XML and graphical format. SQL Server deadlocks using deadlock graphsĪ deadlock graph is a visual representation of the deadlock processes, their locks and the deadlock victim. Session 1 with deadlock priority: -5 < Session 2 with deadlock priority: 5 ![]() Session 1 with deadlock priority: Normal (0) Session 2 with deadlock priority: -7 Session 1 with deadlock priority: Normal (0) > Session 2 with deadlock priority: Low (-5) Let’s look at a few examples of deadlock priority statements. We can also set numeric values for the deadlock priority from -10 to 10 (total 21 values).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |