This enables tracing of Open Server events. A string containing numeric flag identifiers is used to generate Open Server diagnostic information.
This parameter is static.
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 |
For example:
sp_configure DCSERVER, ’srv_traceflags’, ’3’
This parameter is dynamic.
