If the scope of the trace flag is global only does it mean I can't use it only for one connection while not affecting the performance of others?

enter image description here

up vote 3 down vote accepted

If the scope of the trace flag is global only does it mean I can't use it only for one connection while not affecting the performance of others?

The scope signifies the affect of trace flag, a global scope means it will be applicable to all connections of SQL Server, it cannot be made to work only for particular connection/session. On the other hand trace flags whose scope are limited to session will be applicable to particular session.

If you refer to Trace Flags documentation it says

Trace flag behavior may not be supported in future releases of SQL Server.

If you are using SQL Server 2008 and above you have extended events to get deadlock information. Please see

You dont have to enable 1204 traceflag if you want to get deadlock info.

You can use my script to get the deadlock graph which uses event notification.

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.