[dba-SQLServer] Insufficient information about deadlocks

Nancy Lytle nancy.lytle at gmail.com
Tue Sep 30 14:18:42 CDT 2008


Check out sp_blocker_pss80.sql, I found it on the web.  It gives good info on blocking and who is blocking what.  There are some other ones out there but this is the one I use throughout the day to get an eye on things, or I use it when there is a complaint about slowness, etc.
Nancy Lytle N_Lytle at terpalum.umd.edu



 EMAILING FOR THE GREATER GOODJoin me

> Date: Tue, 30 Sep 2008 11:15:07 -0300> From: fuller.artful at gmail.com> To: dba-sqlserver at databaseadvisors.com> Subject: [dba-SQLServer] Insufficient information about deadlocks> > We occasionally get deadlocks reported from our error handler in a> particular sproc. What mystifies me is that this sproc is simply doing a> select from a few tables, based on two IDs. I can't pin it down. I know that> this procedure was the victim but I don't know who the victor was. How can I> track this down?> > Thanks,> Arthur> _______________________________________________> dba-SQLServer mailing list> dba-SQLServer at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> http://www.databaseadvisors.com> 


More information about the dba-SQLServer mailing list