<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">


In your industry, you might experience a slow down at some point within your Microsoft Dynamics GP system. Next, it's troubleshooting time.

This can be challenging to your daily business operations and requires the implementation of a strategic game plan. Without further preface, let’s dive into four ways you can troubleshoot performance issues in your system.

1. Define “slow”: Before finding a solution, understand your issues and how it affects your operations. Did the specific task take significantly longer starting on a certain date? How long does this process normally take? Did anything change in your environment, server or application since this started happening? Is there a certain time of the day that it seems to be worse?

2. Set a benchmark: Take a backup of the database you're troubleshooting and copy it into a TEST database. Run the process on the TEST database and mark down how long it takes.

3. Break it down: There are far too many variables in play with the architecture of Microsoft Dynamics GP to just randomly troubleshoot. By isolating the issue down to a smaller scale, you’ll be able to uncover more clues as to what is causing it and thus be able to put a resolution in place.

  • Network - Time the same process directly on a client on the SQL server and then again on a locally installed or RDS client. If vastly different, then I would put your focus on troubleshooting network bandwidth.
  • Server – Check server logs, new applications that were installed, windows updates, group policy changes, anti-virus exclusions for database files. Monitor overall server CPU and memory utilization.
  • Client Application – Test the issue from two different Microsoft Dynamics GP application installs and compare the results. Remove products from the Dynamic.set file and test again. 
  • Database – Check to see if database maintenance is being ran on each database. Check knowledge base articles for potential known issues with Microsoft Dynamics GP or ISV product versions. Start a SQL profile trace to capture more detail on what is going on during this process. Export the results to an Excel spreadsheet and then narrow down the result set by sorting by failures, a specific user or largest processing time of a task. 
  • User/Company – does the same slowness happen for all users in all Great Plains companies or not? If yes, then you can rule out a specific user or user security.

How to troubleshoot performance issues in Great Plains Dynamics (2)

4. Document each step of the process: This can be a tedious process that's rarely solved in the first attempt. It usually takes some time to isolate, test and monitor—then repeat this process. The last thing you want to do is start from the beginning and not remember what you have completed in your troubleshooting process.

For more GP tips and tricks check out our webinar session, found in the link below.

Demo - Let's Learn Live - Microsoft Dynamics GP


Discuss this post

Recommended posts

The holiday season is upon us, and busy times are ahead for retailers. Holiday retail sales are expected to grow between 4-6% this year, and ecommerce sales are projected to grow up to 14.3%. To prepare for an uptick, retailers are stocking up on employees with stores like Nordstrom planning to hire 20,000 employees for the holidays. It can be difficult for retailers to maintain the status quo with their systems during this crazy time of year. Cyber attacks have been a growing concern for retailers over the past decade. In 2013, roughly 40 million Target customers had their credit card information stolen by hackers in the first three weeks of the holiday season. In 2020, 24% of all cyberattacks were targeting retailers. Alongside cyber threats, retailers must consider the influx of customers that visit their websites during the holidays. A bogged-down website due to system overload can bring a nightmare to life for retailers, leading to abandoned carts and a decrease in customer satisfaction.  To ensure that your business is ready for the holiday season, perform an operational assessment of your system.
At Columbus, we believe that with the right partner, IT outsourcing can shift your business from going with the flow to driving it. It can actually put you in the right position to be proactive, especially in the face of change. We all need this right now.
Adoption of cloud solutions is spreading far and wide. Many businesses have turned to cloud ERP systems to reduce human capital costs, others to increase efficiency and flexibility – all valuable benefits amid ongoing disruption. However, continuous cloud updates are not a ‘fix-all’ solution to ensure ongoing operations. Thorough release management of updates and implementation of sound testing strategy must be used to ensure consistent operational functionality and security.
Dynamics 365 is evolving rapidly, and many companies are in doubt about how to react. Columbus’s dedicated team gives them a helping hand.
For many of us, the idea of embarking on a cross-country driving trip without a solid roadside assistance plan like AAA in place would be unthinkable. When you're stuck by the side of the road with an empty gas tank or a flat tire in the rain, you need to know that 24/7 support is just a quick call away. And the peace of mind that brings you is more than worth the reasonable price you pay for the service. It means you get to relax and listen to your audiobook while you wait for the cavalry to arrive, instead of nervously counting the granola bars in your glove compartment.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down