• Adam Thurgar

What trace flags are on?


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).


5 views

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 compatibility level of 110 (SQL Server 2012), but when run unde

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 from the software provider is always the same - you have index f

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 from. They also knew that deleting large amounts of data causes t