More about Trace Flags…


Trace flags are real helpful when it is used for a specific requirement. Trace flag can set a specific server characteristic or turn off a behavior.

We have Global and Session level trace flag.

There are some recommendations which Microsoft have made for these trace flags:

Global trace flags which are set at server level needs to be set via startup parameter (-T)

Trace can be enabled or disabled using DBCC TRACEON or DBCC TRACEOFF commands

I have already written a topic on DBCC TRACESTATUS which will pull details of which trace is currently active.

https://smartsqlserver.wordpress.com/?s=DBCC

I am looking forward to hear from you to understand if you use any special trace flag for your specific requirement.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s