Wednesday, July 17, 2013

Trace Flags

What is a trace flag?

These are used to assign specific characterstics or switch off particular behavior temporarily or permanently.

How to assign trace flag

1. SQL Server configuration manager - SQL Server - Properties - Advanced- Startup parameters
2. Add Trace flag(s) to engine -T4199
dbcc traceon (4199, -1)
dbcc traceoff(4199, -1)   (-1 switches trace flag globally)

net start Mssqlserver\InstanceName  /T4199


No comments: