<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

Is your organization equipped to handle the loss of a key IT team member? Will certain critical functions within the organization get thrown off gear when that person leaves? Can the organization afford the risk?
In 2018, Black Friday sales pulled in a record $6.22 billion in online sales and 2019 could very well beat that number. Regardless, between Black Friday and Cyber Monday, this year's post-Thanksgiving weekend will be one of the biggest days in American retail.
Your ERP go-live is a huge milestone and major victory, but it's by no means the final step in your ERP investment journey. While going live on-time and on-budget is a measure of success, it’s just one part of the ERP realization puzzle—not the finish line.
Often we come across tech news that amazes us and in the blink of an eye, it’s implemented. New technology can push the frontiers of what’s possible and imaginable. A classic example is Microsoft’s continuous update cycle for Dynamics 365 for Finance & Operations because it allows businesses to simplify their operations and free up resources to add value.
Is your organization equipped to handle the loss of a key IT team member? What if your organization is thrown into a crisis when that person leaves? Is this risk affordable? Organizations need to develop a contingency plan to reduce its dependency in the event of personnel being away.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down