July 3, 2013 at 3:26 am
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
July 3, 2013 at 3:40 am
Hey, what type of indexing are you doing?
can you tell me a little more?
July 3, 2013 at 5:08 am
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
July 3, 2013 at 7:14 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply