Are SQL Server Trace flags 1204 or 1222 used to capture deadlocks?
説明
Microsoft has suggested to remove the dead lock trace flags (1204 and 1222) permanently on all the SQL server instances. Is the SQL Server agent able to capture dead lock details even after removing those trace flags.
Can these trace flags be removed and will Foglight still capture deadlocks?
対策
The SQL Server agent's trace mechanism does not use the trace flags 1204 or 1222 to collect deadlocks. When extended events is not used then Foglight creates a SQL profiler trace using sp_trace_create and sp_trace_setevent to define what events we catch, i.e. the deadlock graph is 148.