Manoj Singh Panwar

Manoj Singh Panwar

  • NA
  • 4.6k
  • 1.1m

Trace frag

Dec 20 2011 11:22 AM
hi, 
What is meant by the term trace frag in sql ?

Answers (2)

0
Aarti

Aarti

  • 0
  • 1.1k
  • 126k
Dec 21 2011 1:56 AM
HI Manoj,

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.

0
Satyapriya Nayak

Satyapriya Nayak

  • 0
  • 39.3k
  • 13.3m
Dec 20 2011 1:01 PM
Hi Manoj,


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