Summary information |
|
|---|---|
Default value |
0 (off) |
Valid values |
0 (off), 1 (on), 2 (on, print summary) |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System administrator |
Configuration groups |
Lock Manager, SQL Server Administration |
print deadlock information prints deadlock information to the error log.
If you are experiencing recurring deadlocks, setting print deadlock information to 1 provides you with detailed information in the error log that can be useful in tracing the cause of the deadlocks. However, setting print deadlock information to 1 can degrade Adaptive Server performance. For this reason, set print deadlock information on only when you are trying to determine the cause of deadlocks.
Use sp_sysmon output to determine whether deadlocks are occurring in your application. If they are, set print deadlock information to 1 to learn more about why they are occurring. See the Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.
A value of 2 allows you to print a summary of deadlock information to the error log (as opposed to the detailed information a value of 1 provides). For example:
Deadlock Id 34: Process (Familyid 0, Spid 70) was waiting for a 'exclusive page' lock on page 10858346 of the 'equineline_job' table in database 18 but process (Familyid 0, Spid 88) already held a 'exclusive page' lock on it. Deadlock Id 34: Process (Familyid 0, Spid 88) was waiting for a 'exclusive page' lock on page 11540986 of the 'equineline_job' table in database 18 but process (Familyid 0, Spid 70) already held a 'update page' lock on it.
