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?
SnapOverflow
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?
Yes, the trace flags are grouped by area of SQL Server - the first two digits always denote the area. For example:
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.
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.