Home Forums SQL Server 2008 SQL Server 2008 - General Online Indexing Being Blocked RE: Online Indexing Being Blocked

  • July 3, 2013 at 5:08 am

    #1629483

    Denesh Naidoo (7/3/2013)

    Hi All,

    Running SQL Server 2008 R2 Enterprise Edition. The environment runs 24/7

    Had a normal indexing job...but this was obviously being blocked by user processes.

    Changed to Online Indexing...but i'm still having this issue which I don't understand why.

    Any assistance is greatly appreciated.

    Thanks

    Denesh

    Online index rebuilds still require a schema lock. Can you inspect the type of lock? What type of statement is blocking the rebuild?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato