What are trace flags?

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.

• Pass Microsoft mcad - MCAD
• Click here to download mcitp test study guide and practice question.
• Pass Microsoft mcitp-database-administrator - MCITP Database Administrator
• Click here to get free mcitp-database-administrator-sql-server MCITP Database Administrator SQL Server exam practice questions.
• Become Microsoft MCITP Database Administrator SQL Server 2005 certified.
• Click here to download mcitp-sql-server test study guide and practice question.
• Download free practice test for Microsoft MCP exam.
• Download free practice test for mcsa-2000-to-2003 MCSA 2000 to 2003 exam.
• Click here to download mcsa-to-mcse-2003 test study guide and practice question.
• Become Microsoft MCSE certified.
• Get certified in first attempt download mcts-sql-server-2005 - MCTS SQL Server 2005 simulation.
• Pass SQL Server 2005 Implementation in first attampt.
• Click here to get free 70-444 SQL Server 2005 Optimizing and Maintaining exam practice questions.
• Become Microsoft SQL Server 2005 Design certified.

• Previous Entry: What is piecemeal restore?
• Next Entry: What is a database diagram?