Home Forums SQL Server 2005 Administering BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005 RE: BLOCKING CAUSED BY REORGANIZE OF INDEX JOB IN SQL SERVER 2005

  • Not enough information to help. Exact statement that is being blocked. Exact statement (not batch) that is causing the blocking. The Wait time. The exact lock types. The object names. At an absolute minimum. The full blocking chain (with all wait types) would help.

    Otherwise it's like calling a mechanic and telling him your car won't start but not giving any other information.

    Oh, and if it's the select that's blocking the reorganise (which is the opposite of what you've been saying), then that's completely expected. Optimise the select to run in less time.

    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