June 27, 2014 at 8:25 am
Hi Team,
Create a server side trace to capture locks.
How to indlude/Create "Save DeadLock XML events Seperately" physical file using server side trace script.
June 27, 2014 at 8:32 am
Are you confined to using server side trace to do that?
Or can you use extended events as an option?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 30, 2014 at 4:47 am
system_health extended event session is already capturing deadlock information for you if you haven't disabled it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply