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... ?SQL profiler - Events Locks - Lock::Deadlock.
Mel|||Look at
http://www.sql-server-performance.com/deadlocks.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_5xrn.asp?
http://support.microsoft.com/default.aspx?scid=kb;en-us;832524
Regards
Amish Shah|||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