Interview Questions
1. Name some of the Important Trace flags and their functionality?
Trace Flag: 1204
This trace flag lets SQL Server to log detailed deadlock information to SQL Server Error Log in text format. In SQL Server 2008, this trace flag is only available at the Global Level (i.e. applies to the SQL Server instance). In my experience, it is worth turning this trace flag on, only for debugging purposes
Trace Flag: 1222
Similar to trace flag 1204, this trace flag lets SQL Server to log detailed deadlock information to SQL Server Error Log in XML format.
Trace Flag: 3226
In an environment where database backup is frequently performed, it is a good idea to turn trace flag 3226 on, to suppress an
entry to the SQL Server Error Log for each backup. This is beneficial as the bigger the log, the harder it is to find other
messages. However, you will need to ensure that none of your scripts or systems rely on the backup entry detail on the SQL
Server Error Log.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment