[dba-SQLServer] Insufficient information about deadlocks

David McAfee davidmcafee at gmail.com
Tue Sep 30 11:58:12 CDT 2008


Arthur do you select using nolock? I try to make it a habit when selecting
Snapshot type recordsets.

SELECT SomeFields FROM sometable WITH (NOLOCK) WHERE pkid = @SomeID

On Tue, Sep 30, 2008 at 7:15 AM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> 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