Hi Viewers, this post is regards getting deadlock information/details into error logs.
Trace flag 1204
Returns the resources and types of locks participating in a deadlock and also the current command affected.
Scope: global only
Trace flag 1222
Returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema.
Scope: global only
--By Shivasagar V
No comments:
Post a Comment