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

  • GilaMonster (9/30/2013)


    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.

    i already got my answer from you thanks a lot