• Thanks for your response Grant!!

    Grant Fritchey (2/17/2014)


    Also, using table locking hints is pretty severe in terms of blocking off access to the system. Are you sure you need that level of locking?

    Yes, it is our intention to block off all access when the table is locked. Its the way in which we hand user sessions.

    So, the QueueItem has a full lock, the HandlerRule has a shared lock and the index requires some level of locking. I still can't see where the deadlock would come from. The Queueitem table is a large table however the HandlerRule table contains only a few row.

    Could a deadlock occur when the index is being rebuilt and sql attempts a full lock on the QueueItem table?

    The problem I'm trying to get my head round is the index rebuild causing a deadlock. Any ideas?

    Thanks again.

    --------------------------------------------

    Laughing in the face of contention...