Following on from my previous post: Solving Performance Problems with Microsoft Dynamics GP and Windows 10 – Part 1, I was still not happy with the performance of Dexterity and Microsoft Dynamics GP on my newly updated Windows 10 development machine.
This article takes you through the steps to get your Dexterity and/or Dynamics system running fast on Windows 10.
I normally don’t post multiple articles in one day, but it was worth posting this one and the previous two as soon as possible to help others out there facing the same issues.
After resolving the pause on exit issue discussed in the previous post, I noticed that Dexterity and Microsoft Dynamics GP where still very sluggish when running. It was taking much too long to log in and everything was like I was running through molasses.
Checking the Task Manager, I could see fairly high CPU usage. Sorting by the CPU column, the culprit was the Antimalware Service Executable. This Windows process is the real-time processing component for Windows Defender.
I have seen issues before with anti virus or malware solutions causing performance issues for Microsoft Dynamics GP and Dexterity, and the easiest way to resolve them is to add some exclusions to the settings for the application.
Part of the issue is that the Dynamics dictionary is a very large single file and the anti virus solution often wants to check the entire file when only a small part of it is being read. So you want to exclude the file type with the extension .DIC.
This is the same issue with the database and log files maintained by SQL Server. So you want to exclude the folder where SQL Server stores its .mdf and .ldf data files.
As a final step (that delivered some of the best performance improvement), I also excluded the executables for Dexterity, Dexterity Utilities and Dynamics. I have five versions of each installed, so that needed 15 entries.
To make the changes on your Windows 10 system running Windows Defender follow the steps below. If using a different anti virus or malware solution, you can add the same exclusions anyway.
- Select Start >> Settings
- Select Update & Security >> Windows Defender
- Under Exclusions, click Add an exclusion
- Under Folders, click Exclude a folder
- Locate the SQL Server Data folder and exclude it. On my system it was
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
- Under File Types, click Exclude a file extension
- Add .dic as an exclusion
- Under Processes, click Exclude a .exe, .com or .scr process
- Navigate to the Dex.exe, Dexutils.exe for each version of Dexterity and add it
- Also navigate to the Dynamics.exe for each version of Microsoft Dynamics GP and add it
Now test out how fast your system runs Dexterity and/or Microsoft Dynamics GP. Zoom Zoom. 🙂
Hope you are happy with your Windows 10 upgrade now.
PS: I know adding exclusions weakens your protection, but it does stop you pouring a liquid into the machine in the hopes of dissolving the molasses.
This article was originally posted on http://www.winthropdc.com/blog.