• No.

    Are you seeing deadlocks? Are you having queries failing with the error "Transaction X was deadlocked and was chosen as the deadlock victim"? Deadlocks and blocking are two different (though related) things. If you're just having blocking, the deadlock trace may not show anything up at all.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass