Tuesday, December 9, 2014

How Trace Flags are categorized in Microsoft Sql Server...

I have just gone through a very Old post of Andrew Kelly, posted on  June 21, 2009 about categories of Trace Flags in Sql Server. This provides some level of insight into how Microsoft categorizes their trace flags.

As per Paul " These are from memory so they may not be 100% accurate or complete."  

Trace flags are grouped by area of SQL Server - the first two digits always denote the area. 

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


References: Andrew Kelly Blog

No comments:

Post a Comment