Please let me know how to add deadlock trace in startup parameters of SQL cluster
I have got below idea but not sure if this is OK to go with...
1) Add trace flag in active node without restart through Configuration Manager
2) From the Cluster manager, take the SQL services to offline and bring it online(it will restart the sql services on active node without failover)
3) Now add trace flag in passive node without restart, then again from Cluster manager.. failover to passive and failback again to active node to make the changes effective
please help if this method is OK