hi,
What is meant by the term trace frag in sql ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
AartiPosted Dec 21, 2011, 1:56 AM
A Trace Flag (not Trace Frag) is used inorder to
activate/suppress a certain behaviour of the SQL Server.
You need to restart the SQL Server after adding the Trace
Flag.
Satyapriya NayakPosted Dec 20, 2011, 1:01 PM
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.
Please refer the below link
http://msdn.microsoft.com/en-us/library/ms188396.aspx
Thanks