Turning OFF Deadlock Traceflag

johnnywyskieljohnnywyskiel Posts: 4 Bronze 1
edited April 18, 2016 6:37AM in SQL Monitor Previous Versions
Is there a way to configure RedGate NOT to turn on the Deadlock traceflag? Accorting to the logs, SQL Monitor is turning on Traceflag 1222 even if I turn it off.

One of the database contains ePHI data and since flag 1222 will output the queries of the deadlocked sessions, it's possible that the deadlock output into the error log could have sensitive data. Per our auditor, we should turn off that output into the SQL Server error log.


  • Hi johnnywyskiel,

    Thanks for posting on the Redgate forums.

    There isn't a method for setting this within the SQL Monitor UI, however, it should be achievable by editing the user SQL Monitor uses to log in to SQL.

    If you remove sysadmin privileges from the user this deny him the right to turn on the Trace 1222 flag. You would then need to apply the rest of the permissions on this page to ensure SQL monitor continues to function correctly. Please let me know if you need any further assistance with this.

    http://documentation.red-gate.com/displ ... ermissions
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.