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. Start a SQL profile trace to capture more detail on what is going on during this process. Check knowledge base articles for potential known issues with Microsoft Dynamics GP or ISV product versions.

Database – Check to see if database maintenance is being ran on each database.Remove products from the t file and test again. Client Application – Test the issue from two different Microsoft Dynamics GP application installs and compare the results.Monitor overall server CPU and memory utilization. Server – Check server logs, new applications that were installed, windows updates, group policy changes, anti-virus exclusions for database files.If vastly different, then I would put your focus on troubleshooting network bandwidth. Network - Time the same process directly on a client on the SQL server and then again on a locally installed or RDS client.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. Break it down: There are far too many variables in play with the architecture of Microsoft Dynamics GP to just randomly troubleshoot. Run the process on the TEST database and mark down how long it takes.ģ. Set a benchmark: Take a backup of the database you're troubleshooting and copy it into a TEST database. 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?Ģ.

Define “slow”: Before finding a solution, understand your issues and how it affects your operations. Without further preface, let’s dive into four ways you can troubleshoot performance issues in your system.ġ. This can be challenging to your daily business operations and requires the implementation of a strategic game plan. In your industry, you might experience a slow down at some point within your Microsoft Dynamics GP system.

Dynamics gp process monitor