Summary information |
|
|---|---|
Default value |
0 (off) |
Valid values |
0 (off), 1 (on) |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
print deadlock information enables the printing of deadlock information to the error log.
If you are experiencing recurring deadlocks, setting print deadlock information to 1 provides you with information that can be useful in tracing the cause of the deadlocks. However, setting print deadlock information to 1 can seriously degrade Adaptive Server performance. For this reason, you should use it 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 Guide for more information.
