Use the srv_traceflags parameter to turn on trace flags to log Open Server diagnostic information.
Trace Flag |
Description |
---|---|
1 |
Traces TDS headers |
2 |
Traces TDS data |
3 |
Traces attention events |
4 |
Traces message queues |
5 |
Traces TDS tokens |
6 |
Traces Open Server events |
7 |
Traces deferred event queues |
8 |
Traces network requests |
sp_configure DCSERVER, ’srv_traceflags’, ’3’
This parameter is dynamic.