Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Online Indexing Being Blocked Expand / Collapse
Author
Message
Posted Wednesday, July 3, 2013 3:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:44 AM
Points: 87, Visits: 1,512
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
Post #1469937
Posted Wednesday, July 3, 2013 3:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 21, 2014 1:16 AM
Points: 51, Visits: 338
Hey, what type of indexing are you doing?
can you tell me a little more?
Post #1469947
Posted Wednesday, July 3, 2013 5:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:21 AM
Points: 7,135, Visits: 12,749
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
Post #1469996
Posted Wednesday, July 3, 2013 7:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 225, Visits: 1,755
About online index locking:
http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-830-unicorns-rainbows-and-online-index-operations/
Post #1470040
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse