-
Title
Is it possible to schedule the maintenance (Index rebuilt) at a specific date/time? -
Description
Is it possible to schedule the maintenance (Index rebuilt) at a specific date/time (e.g. during the night)?
-
Resolution
WORKAROUND:
None
STATUS:
Enhancement request CR 235321 has been submitted to Development for consideration in future release of Performance Analysis for SQL Server. -
Defect ID
CR 235321 -
Additional Information
If the site runs maintenance on all their databases and therefore does not need the maintenance routine to be run in PA (Agent Admin -> Performance Repository -> Maintenance tab), then the PASS maintenance routine should be disabled.
Rather than disabling the maintenance by un-checking options on the maintenance tab (Index Rebuild and Daily Maintenance), the suggestion is to run the following sql against the repository database...set the IS_SELF_CONTAINED flag to 1 in the QUEST_REP_VERSION table:
UPDATE QUEST_REP_VERSION
SET IS_SELF_CONTAINED = 1which will prevent PASS maintenance from running and the user will be responsible for maintaining the repository db.