Topic: Audit of locks and productivity
There is a need to write down the data on transactions causing locks, and also on transactions demanding many resources.
command DBCC TRACEON (1204), a flag 1204 on locks. I can not understand where will write down the data about locks and as them to derive.
Somebody can prompts a script which kills all transactions dead-lock? I want job to create, which would kill all at night.