How can I create a maintenance plan in SQL Server 2005 or later to optimize database performance?
A SQL maintenance plan for rebuilding indexes and setting the index free space percentage to 10% within the Symantec/Altiris databases should be scheduled to run at least monthly (preferably weekly). This maintenance plan should also be configured to update column statistics (index statistics are updated during the index rebuild process). It is recommended that this plan be scheduled to run at a time when database utilization by the Symantec applications is at its lowest. This could be on a Sunday during the day or a during a scheduled maintenance cycle, etc.
To build the SQL Maintenance plan for SQL 2005 or later:
Once the wizard is finished with creation, you can click Close. To execute the maintenance plan, right-click it in the left hand Object Browser pane and click Execute.
* If you are scheduling this job to run periodically ensure you have the SQL Server Agent service running.
Additionally: TECH212291 contains a script that can be run to perform the Maintenance on a more regular basis.
Additional Performance Considerations: