top of page
Search

What trace flags are on?

  • Adam Thurgar
  • Sep 20, 2018
  • 1 min read

Have you ever wondered about what trace flags are enabled on your SQL Server.

With all the different 'best practices' for tempdb with -T1117 and -T1118 and now -T3427.

What about your deadlock trace flags -T1204 and -T1222.

The easiest way to find out what trace flags are on is to run dbcc tracestatus (-1).


 
 
 

Recent Posts

See All
Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...

 
 
 
Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...

 
 
 
Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...

 
 
 

Comments

bottom of page