Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Apart from memorizing what every trace flag does, is there an easy way to remember what groups of trace flags do. The first digit of the trace flag number looks like it may mean something?

Does anyone know what this first digit denotes?

share|improve this question

2 Answers 2

up vote 8 down vote accepted

Yes, the trace flags are grouped by area of SQL Server - the first two digits always denote the area. For example:

  • 6xx are Storage Engine access methods
  • 8xx are buffer pool
  • 12xx are lock manager
  • 14xx are database mirroring
  • 25xx, 52xx are DBCC related
  • 30xx, 31xx, 32xx are backup/restore
  • 36xx are SQL Server general 'run-time'
  • 55xx are FILESTREAM
  • 73xx, 74xx are query execution
  • 76xx are full text related (?)
  • 75xx are cursors
  • 82xx are replication

These are just the ones I remember as I don't have source code any more (I wrote a bunch of the code and owned the whoe Storage Engine for 2008).

There's no easy way to remember what each one does.

Hope this helps.

share|improve this answer
    
this is exactly what i wanted! thanks Paul! –  Nick Kavadias Jun 21 '09 at 15:44
3  
Paul, I'm disappointed. You don't have the entire source code for SQL memorized? –  mrdenny Jun 21 '09 at 21:05

Besides what Paul has posted, you can google for most trace flags and get a description of them. Even a lot of the undocumented ones are out there. Most of the trace flags which are documented that you'll need to use all the often will be available in Books OnLine.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.