September 8, 2009 at 12:07 pm
I created a rebuild index job to run weekly on Sundays at 3am. I just used the wizard to create the maintenance plan, nothing fancy. The job has been running fine for weeks, takes about 20 minutes each time. But this past sunday, it ran for over 24 hours, someone went in and canceled it because the job was running too long. Does anyone know why this would happen all of a sudden? It's been pretty consistent since we first created the job back in May so it's been running smoothly for the past 4 months. We are running SQL Server 2008 Standard (x64) and it has SP1.
Any ideas why the rebuild index job would suddenly run so long? Thanks for the help!
September 8, 2009 at 1:45 pm
online or offline rebuild.? A sudden long run time is often due to the process being blocked out by another process.
---------------------------------------------------------------------
September 8, 2009 at 1:46 pm
user activity? maybe some unfinished transaction ?
September 8, 2009 at 3:23 pm
It is an offline rebuild. I wonder if there was something that might cause it to be blocked but I wasn't the one that stopped the job at the time so I was able to check it out while it was still running. By the time i was notified of it, there wasn't any open transactions or any locks.
The job runs at 3am and is usually done by 3:20am. I'm not sure what caused it to run that long. Is there any other way I can figure out why the job took so long to run? Or is it pretty much nothing I can do at this point to find the cause?
September 8, 2009 at 3:26 pm
how big is the database. make sure you have enough disk space for it. almost need double the size of index sapce. also check in active proecesses if reindex is running.
:crazy: :alien:
Umar Iqbal
September 9, 2009 at 7:50 am
not much you can do post the event. set up some monitoring for the next run. Any new batch jobs been introduced that run at the same time?
---------------------------------------------------------------------
February 12, 2013 at 10:44 pm
Did you change the Recovery Model? In FULL recovery model Index Rebuild takes long time due to logging of each and every page allocation.
February 13, 2013 at 3:31 am
note: 3 year old thread!
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply