<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

Three decades of ColumbusCare managed services for our clients has helped us to finetune the three best ways organizations can leverage a service provider for application and infrastructure management. We've listed them as follows:
According to GlobeNewswire, the application management services (AMS) market size is forecast to cross the $4.1 billion mark by 2025 after clocking a CAGR of 22.3% from 2017 through 2023.
User Acceptance Testing gives an organization the chance to test its software (a new implementation, an upgrade or even a customization) by leveraging real-world examples and personnel who will be using the software routinely. It is often the final stage of the implementation process—conducted to ensure that system requirements meet business needs while allowing for issues (if any) to be fixed before the system goes live (which is the premise of effective application management service).
It is now widely recognized how crucial it is for companies to strengthen overview and insight into their data, and to use it efficiently and systematically. This in-vogue phenomenon—known as digital transformation—allows organizations to optimize processes, supply chain value and competitiveness. Accurate identification of optimal trading opportunities via new technologies is an added benefit.
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?
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down