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

  • September 30, 2013 at 7:55 am

    #1654563

    GilaMonster (9/30/2013)

    Ok, so something (unknown) is causing something else (unknown) to be blocked for (unknown) duration with (unknown) lock types requested and (unknown) lock types held on (unknown) objects.

    Good luck fixing this, because currently there's no way that anyone else can help.

    so something (Select statement) is causing something else (alter index reorganize ) to be blocked for (5 to 10 min) duration with (unknown) lock types requested and (unknown) lock types held on (SAME) objects.