Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » rebuilding indexes
Add to briefcase
12 posts, Page 2 of 2
««12

rebuilding indexes Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Roy Ernest
Posted Friday, October 23, 2009 7:37 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:52 AM
Points: 3,280, Visits: 6,622
That means that by the time you went to kill it 116 was already finished. How many rows does the table have? When you run the command sp_who2, what is the status of the create index spid? Also please provide the script that you used for recreating index.

-Roy
Post #807879
George M Parker
Posted Friday, October 23, 2009 11:12 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 09, 2013 1:13 PM
Points: 516, Visits: 1,004
After being bitten by the blocking bug in the past where the index rebuild jobs were blocked by a connection from the application that wasn't closed, I implemented a standard practice to include a lock time out in my script that rebuilds the indexes: SET LOCK_TIMEOUT 900000; -- Set it to 15 minutes to avoid causing blocking

So now instead of the index rebuild job being blocked, it just times out after 15 minutes and moves on to the next index.
Post #808072
« Prev Topic | Next Topic »

Add to briefcase
12 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.