Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. For example, if
trace flag 3205 is set when an instance of SQL Server starts, hardware compression for tape drivers is disabled. Trace flags are
frequently used to diagnose performance issues or to debug stored procedures or complex computer systems.
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