Is Dynamics GP Taking Forever to Post?
Posted by Donna Krizik on June 19, 2015
Are monthly maintenance tasks like running reconcile, taking hours, or worse, days? Maybe it is time to take a look at the size of your database. When we take on a new client, one of the first orders of business is to conduct a process review, where we document the client’s system and identify any critical tasks and map a plan for future growth. Often, during these reviews, we find ways to streamline operations and improve system performance.
One area that can really slow down performance are bloated databases, full of unnecessary years of detail.
Clients at most risk are the ones with high sales order transaction volumes. The image below shows the volume of automated sales documents coming into Dynamics GP over a two-week period for a high-volume customer.
Many customers neglect data management, only handling it on a repair and maintain basis, with no regular data archiving or purging. As a result, their databases grow exponentially over the years. They don’t even know that database archiving and purging is a critical task which can greatly improve daily performance, avoid data corruption and system crashes. The image below shows the actual database size progression over 6 years, and estimation for 2 additional years.
The transaction counts consuming the storage were heavily weighted to sales order processing and receivables management based transactions (87%). Within their current environment, available disk space was nearly non-existent, which meant whenever they ran maintenance routines, processing speeds grounded to a halt.
To add insult to injury, frequently, the customers who are most affected also are running on older versions of Dynamics GP and probably older versions of SQL server, which compounds the problem.
What is the solution?
There are purge routines available within Dynamics GP, but with the bloated database size and the processing power of the server environment, the task would require days worth of processing to complete the task. Not the most desirable solution.
What Crestwood recommends, and put into action in this case and in many others, is an application called Company Data Archiver (CDA). CDA accomplishes 4 key objectives:
- Reduced hardware costs (no need to upgrade)
- Increased performance
- Faster upgrades and backups
- No more clutter
We put CDA in action at our client site, with astounding results. It took a database size of 103 GB and reduced it to less than 35 GB, while maintaining the data in an ‘archived company’.
This provides access to all the data (as needed), while removing the closed/old data to a separate company on a routine basis. Additionally, Company Data Archiver provided the necessary SQL Scripting to reallocate the unused space once completed.
Crestwood now strongly recommends that routine data maintenance be performed to minimize the data contained within the ‘Live” database, using the CDA program.
An extra benefit?
Moving ahead with this approach will have an immediate increase in efficiencies of your users and system resources. As a bonus, it provides for an easier upgrade to both Dynamics GP and Microsoft SQL, should you be on that track.
Ah, yes. All technology efforts have to pass the cost/benefit test. If you are currently using the Collections module from Professional Advantage, there is good news! CDA “Express” comes at no additional cost. The Express version lets you archive Master Data, GL and Payables information. If you want to archive Receivables or any of the distribution modules, then you’ll need the full version, which is normally priced at $2,000. Professional Advantage is running a special 10% off promotion through the end of June.
Ready to take it for a test run?
Professional Advantage (and Crestwood) believes in the value of the product so much that they offer a free trial environment with registration keys so you can see how it can help for yourself. Talk to your Account Manager or reply to email@example.com to get the ball rolling.