What are trace flags?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What are trace flags?

Rating:

Trace flags are used to diagnose performance issues or debug stored procedures. Trace flags are of the following two types:

• Session: Session trace flags are active only for a specified connection. A trace flag enabled in a session does not disturb the trace flag opened in another session.


• Global: Global trace flags are set at server level and are visible to every connection. Some of the flags can be enabled at global level, whereas others can be enabled at global or session levels.

Trace flags can be enabled by using the DBCC TRACEON stored procedure, and disabled by using the DBCC TRACEOFF stored procedure. The status of a trace flag can be displayed by using the DBCC TRACESTATUS stored procedure.

Rating: