Use the srv_traceflags parameter to turn on trace flags to log Open Server diagnostic information. Open Server trace flags are described in Table 6-9.
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_text_configure KRAZYKAT, ’srv_traceflags’, ’3’