sp_who and sp_locks on occurrance of deadlock  
Author Message
Altona





PostPosted: Tue Mar 21 08:10:27 CST 2006 Top

SQL Server >> sp_who and sp_locks on occurrance of deadlock

Hi.

I am supporting a client running sql-server standard edition, version
8.00.2039.

We have a deadlockproblem which i'm trying to dig into.
I've enabled trace flag 1204, but i'd like more detailed information when a
deadlock occours.

Is it possible to have the server deadlock handling procedure dump sp_who
and sp_locks to the log-file or another txt file when a deadlock occours,
preferrably before the victim thread is killed ?

Best regards, Erik

SQL Server298  
 
 
jbellnewsposts





PostPosted: Tue Mar 21 08:10:27 CST 2006 Top

SQL Server >> sp_who and sp_locks on occurrance of deadlock Hi

Look at using sp_blocker_pss80 see
http://support.microsoft.com/kb/271509/EN-US/

You may want to apply http://support.microsoft.com/kb/899761 even if you
aren't using AWE.

John



> Hi.
>
> I am supporting a client running sql-server standard edition, version
> 8.00.2039.
>
> We have a deadlockproblem which i'm trying to dig into.
> I've enabled trace flag 1204, but i'd like more detailed information when a
> deadlock occours.
>
> Is it possible to have the server deadlock handling procedure dump sp_who
> and sp_locks to the log-file or another txt file when a deadlock occours,
> preferrably before the victim thread is killed ?
>
> Best regards, Erik
>
>
>
 
 
amish





PostPosted: Wed Mar 22 05:03:11 CST 2006 Top

SQL Server >> sp_who and sp_locks on occurrance of deadlock Have a 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