- #Sql 2012 express maintenance plan update
- #Sql 2012 express maintenance plan full
Check the option to Write a report to a text file and allow it to write to the default location.
#Sql 2012 express maintenance plan full
In the Scan Type section, select Full scan.
#Sql 2012 express maintenance plan update
In the Update section, select Column Statistics Only. Altiris databases uses ntext fields which prevent clustered indexes from being rebuilt while online for those tables that have an ntext column. Make sure that Keep index online while reindexing is unchecked. “Sort results in tempdb” should generally not be used however, if SQL memory resources are low, then this will help, but it does cause rebuilding to take a lot longer. 
Select Change free space per page percentage to and set its value to 10% (20% if only rebuilding indexes monthly). 
In the These databases section, select all the databases you are trying to optimize, such as Altiris, Altiris_Incidents, eXpress, AeXRSdatabase, Symantec_CMDB and Symantec_CMDB_IntelAMT. Make sure that “Rebuild Index” task is at the top. Check the options to Rebuild Indexes and Update Statistics. Leave the default option set to Single schedule for the entire plan… Click the Change button to put in the schedule for this plan. Give the maintenance plan a name such as “Rebuild Indexes for Altiris Databases”. When the SQL Server Maintenance Plan Wizard info page opens up click Next. Right-click on Maintenance Plans and select Maintenance Plan Wizard. Make sure that the SQL Server Agent service is running. To build the SQL Maintenance plan for SQL 2012 or later: 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. How can I create a maintenance plan in SQL Server 2012 or later to optimize database performance?Ī 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).
0 kommentar(er)
