question

Elysian avatar image
Elysian asked

Please let me know how to add deadlock trace in startup parameters of SQL cluster

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

sql serverclusterstrace-flagscluster nodesql services
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Elysian avatar image Elysian commented ·

@WRBI- could you please help

0 Likes 0 ·

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered

Add the traceflags through configuration manager, and don't restart the server/services.

You can activate the traceflag immediately using DBCC TRACEON with the appropriate trace flags

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.