Improving Great Plains Performance

As your database grows, you may experience long wait time when looking up data in Great Plains.  One way to possibly improve your database performance would be to update the statics for the database.  Use the information below to update your database statistics using the Dynamics GP application.

Use the SQL Maintenance window to reconfigure your data table keys for better performance.

Microsoft SQL Server can update statistics automatically. For more information, see your SQL Server documentation.

To update statistics:

  1. Open the SQL Maintenance window. (Microsoft Dynamics GP menu >> Maintenance >> SQL)

    2. SQL Maintenance

  2. Select a database
  3. Select all the tables in the list, and mark the Update Statistics option.
  4. Choose Process.

Posted by Rick Hollis on 6/10/2010 8:31 AM, 0 Comments, Categories: GP,Great Plains,Support

Comments

Mike Gruber says:
6/18/2010 9:26 PM
Rick, would this be something you would recommend be done each month end, yearend or just when you see performance lag?