To generate certain reports, you must enable corresponding configuration options using sp_configure, or edit the server configuration file.
If configuration options are set incorrectly, sybdiag skips the related reports.
|
Option |
Value |
sybdiag Reports |
|---|---|---|
|
enable monitoring |
1 |
Adaptive Server Wait Events Adaptive Server Locks Adaptive Server Deadlock History |
|
wait event timing |
1 |
Adaptive Server Wait Events |
|
deadlock pipe active |
1 |
Adaptive Server Deadlock History |
|
deadlock pipe max messages |
Nonzero value; must be large enough to capture all relevant deadlock rows |
Adaptive Server Deadlock History |