Monday, March 12, 2012

monitoring deadlock

On production we r having lot of deadlock errors. How can i monitor this and
identified sps creating this havoc... ?Perhaps you can use this:
http://support.microsoft.com/?kbid=271509
You might find that this is helpful information as well:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
Keith Kratochvil
"Vikram" <aa@.aa> wrote in message
news:eTt3kRMWGHA.3332@.TK2MSFTNGP02.phx.gbl...
> On production we r having lot of deadlock errors. How can i monitor this
> and
> identified sps creating this havoc... ?
>

No comments:

Post a Comment