<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

Getting started with Azure Cloud infrastructure can be both frightening and exciting! However, the first steps are always the most important, and planning your cloud migration budget is an excellent place to start. It assists you in organizing your procedures, estimating costs, and preparing for the giant leap.
Businesses today operate in a hyper-competitive atmosphere, propelled by constantly evolving digital technologies. Engagement levels between customers and businesses are undergoing paradigm shifts; customers’ expectations and attitudes are placing tall demands on customer service and service delivery management.
Today, every company is a technology company with a continuously increasing reliance on business-critical applications. This makes monitoring, maintaining and managing the entire application portfolio extremely important to – 1) increase operational efficiencies and, 2) maximize return on investment (ROI). Effective application management can ensure both.
With an evolving organization, your business framework will change, creating a pressing need to adopt new IT solutions. The global pandemic has forced companies to minimize manual work and accelerate their digital transformation. As your business-critical applications become more complex, achieving operational efficiency with existing resources can be challenging.
Experiencing downtime can be a nightmare. No one wants it, but companies constantly struggle with it all the same. 
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down