• use dbcc inputbuffer(spid) using the spid of the session that is causing the blocking. That will help you find what query is being run that is causing the blocking. Once that is determined, then it is a matter of tuning or fixing that query.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events