deadlock info

Is there a way to tell which two process' were involved in a deadlck after
it happens?
SQL2K SP3
TIA, ChrisRChrisR wrote:
> Is there a way to tell which two process' were involved in a deadlck
> after it happens?
Not after. You can run profiler and trap the deadlock and deadlock chain
events. But you'll need to add the proper SQL event to really see what
was going on. At the very least, you'll need SQL:BatchStarting and
RPC:Starting. better would be to add SQL:StmtStarting for SQL and
SP:StmtStarting for SPs.
David Gugick
Imceda Software
www.imceda.com|||You can if you're running the output of trace flag 1204 for all connections
to the SQL log.
To do this, issue the following command:
DBCC TRACEON (3605, 1204, -1)
When a deadlock occurs, you'll get a detailed report on the processes, what
objects were locked etc. It's tricky to decipher the output of this trace
flag at first but if you have difficulty post the output back here & I'm
you'll get plenty of help.
Regards,
Greg Linwood
SQL Server MVP
"ChrisR" <bla@.noemail.com> wrote in message
news:OT6gtSozEHA.2568@.TK2MSFTNGP10.phx.gbl...
> Is there a way to tell which two process' were involved in a deadlck after
> it happens?
> --
> SQL2K SP3
> TIA, ChrisR
>