Blog Post

Setting DBCC 1222 on startup

,

Setting DBCC 1222 on startup

The following command is run to gain details on deadlocks.

 DBCC TRACEON (1222,-1)

However, once the SQL instance is restarted this flag is set back to disabled.

Setting DBCC 1222 on startup

To enable it on the instance upon startup:

  1. Open SQL Configuration Manager
  2. Services > Sql Service Instance > Properties > Startup Parameters
  3. Add the following statement: -T1222
  4. Confirm the change by navigating to Advanced > Startup Parameters. This should be grayed out and display the new value that was added at the end with a delimited semicolon.

Setting DBCC 1222 on startup

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating