We have SQL 2005 Ent Edition (SP2) on W2k3 R2 Ent Edition. This OS was previously on Std Edtion and we had done an In-Place upgrade to Ent Edition some time back. Since then the Maintenance plans - Update Stas & Index Rebuild seem to take double
the time to execute. I do believe this could be due to an already busy disk subsystem (RAID 5 array).
Can someone pls advice what could be possible reason for this sudden increase in the maintenance job execution time.
Paul - SQL DBA
View Complete Post