https://www.sikich.com

Database Health and the Check Database Integrity Maintenance Task

James Rodrigues

Feb 21 2018

3 min read

Most users are focused on Dynamics GP performance and the validation of the data within the system. This is extremely important. Yet, we sometimes forget to look under the hood to make sure that everything is humming along the way it should. Specifically, we forget to check the database health to see if the Dynamics GP database needs maintenance.

The backend of GP is SQL. SQL consists of a Database Engine (among other components) that hosts the GP databases where all GP data is stored. When you create a Journal Entry, the entry is written to the GP database in SQL. When you run a report, the data is pulled from the GP database in SQL. As you can see, GP is reliant on SQL for almost all of its functionality.

So this is where the car analogy returns, and you are reminded to check the oil every once in a while. The good news is that SQL itself provides tools to diagnose potential or existing issues within the GP databases or the SQL Database Engine itself. One such tool is called Check Integrity.

Check Integrity is a SQL Maintenance Task that runs validation tests against the selected databases in SQL. One of the main commands it runs is DBCC CHECKDB (). The long and the short of this command is that it looks for potential allocation and/or consistency errors in your databases. This can help catch database corruption in its early stages.

Most users back up their SQL databases, but what use is the backup if it too is corrupted?

Check Integrity can be resource heavy to run, so SQL Management Studio allows you to schedule it to run whenever you like (typically we recommend weekly on a day your team is out of GP, e.g. Sunday). You can even set up alerts if the Check Integrity task fails. This will allow you to nip the issue in the bud before it becomes an irreparable problem.

So remember don’t forget to check under the hood every once in a while…or in this case make sure your engine is checking itself.

If you would like to discuss the Check Integrity Dynamics GP database maintenance tasks (or any other SQL or GP question), please contact us at any time. We can also perform a performance and technical review of your GP and SQL system to make sure that it is optimized and protected. At Sikich, we have consultants that specialize in every aspect of GP and SQL, so please do not hesitate to reach out.

This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.

About the Author

James Rodrigues

Senior Technical Consultant at Sikich. Proficient in SQL and GP/CRM technical aspects. Project Manager for the GP Upgrade Team and Technical Projects.