The deadlock flag ;-T1204;-T1222
Posted on 2013-05-24
Right now I would like to turn on the deadlock trace flat for the MS SQL server 2008 R2 by add ;-T1204;-T1222 to the end of the SQL server startup parameter.
Any one know if this SQL server is clustered, I need to modify the start up parameter of SQL server service on both nodes?
Of course I need to stop the SQL server services from the failover manager.