I know there are a lot of blogs and forums out there explaining what to do to increase performance on any of the Windows Server environments. However, with so much information, I was amazed to find standard settings with the default installation of Windows, can cause major performance problems. The list below is just a few of the most commonly found problems we have identified.
We have found that you need to change the default setups of Windows Server 2008 and Windows Server 2012 for best performance for Microsoft SQL Server and Microsoft Dynamics AX 2009 and Microsoft Dynamics AX 2012.
These settings are:
- Power Option should be set to High performance
- Control panel > All Control Panel Items > Power Options
- Select High performance
- For more information, please read: https://support.microsoft.com/kb/2207548?wa=wsignin1.0
- Set Problem Reporting Settings to “Never check for solutions”
- Control Panel > System and Security > Action Center > Problem Reporting Settings
- Select “Never check for solutions (not recommended)
- Disable “Windows Search” Service
- Administrative tools > Services
- Find the Service: “Windows Search”
- Right click and disable the service.
- Anti-Virus software
- Disable real time scanning on all servers. Depending on the client, this is not always possible. You might have to specify specific Folders and extensions to exclude from the checks. However, the easiest is way to identify if the Anti-Virus software is causing any performance problems, it to disable it and see if it makes any difference in performance.