Configuration Options for sybdiag

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