Reindex Maintenance Plan starts with 15hours delay

Hey there,

on a SS2005 Build 3152 i've scheduled a mp with reindexing a 120 GB db. The mp is scheduled to start every sunday at 08.00am.

In the agents history log i can see that it start its job at 8.00am, but the first reindex starts at 11:xxpm. In the mp history log i can see that it starts at 11:xx pm.

Why do I have such a big delay? Is the job waiting because of some locks, or does the job have to check some things before reindexing? But 15 hours? Is it a bug in mp?

Any ideas?

Thanks in advance
tobiasHi,

does nobody have an idea?

regards
tobias
|||

I would like to know what options you have selected on the MP when you have scheduled this job. Also I would ask whether you have applied SP2 for SQL.

120GB database I would expect it will take some time to finish the maintenance tasks and also check what other processes are running.

|||SP2 and http://support.microsoft.com/kb/933097/en-us are applied.

Other jobs are regular transaction-protocol-backups. The workload on sundays is very low, just a view automatic tasks write to the db.

The MP has to tasks.

1. Reindex
o Connection: Local Server
o Databasese: The ERP Database
o Objects: Table & Views
o Selection:
o % Freespace per Page: 10%
o Sort in TempDB: No
o Index Online: No

2. History Cleanup
o cleans everything older than 4 Month