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... ?
>
Monday, March 12, 2012
monitoring deadlock
Labels:
andidentified,
creating,
database,
deadlock,
errors,
havoc,
microsoft,
monitor,
monitoring,
mysql,
oracle,
production,
server,
sps,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment