To optimize Dynamics GP performance, it is recommended to set up a SQL Server Maintenance Plan to perform a number of maintenance and optimization tasks. The following are the steps to create a typical SQL Server maintenance plan for Dynamics GP. The specific steps for your plan may vary, depending on your needs and setup.
In SQL Server Management Studio, expand your SQL Server instance in the Object Explorer and then expand the Management folder. Right-click on Maintenance Plans and select Maintenance Plan Wizard:
Click on Next on the Maintenance Plan Wizard window.
Give your maintenance plan a Name and (optionally) a Description. Select the Separate schedule for each task radio button and click on Next.
On the Select Maintenance Tasks window choose all the tasks selected in the following screenshot:
Click on Next and Next again on the Select Maintenance Task Order window. (Since you selected to set up a separate schedule for each task, the Select Maintenance Task...