Total Pageviews

Search This Blog

Wednesday, October 28, 2015

Anti-Virus Exclusions for SQL Server, SSRS and Dynamics AX AOS Servers for improved performance

This post is about sharing my experience where I helped some clients to improve their overall application performance.
Quite often I have seen, we neglect the anti-virus softwares which run on our production boxes and scan application and data files, thereby leading to disk I/O and performance issues.
We need to add an exclusion list in our Anti-Virus software to exclude scanning files for SQL, SSRS and Dynamics AX 
A. SQL Server: 

The following paths needs to be excluded:
Sqlserv.exe C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn

Full Text Index Catalog C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\FTData
Data Files (.mdf/.ndf) D:\DATA (Path where SQL Database data files are located)

Log Files (.ldf) E:\Logs (Path where SQL Log files are located)

TempDB files F:\Tempdb (Path where tempdb files are located)
Backup Files (.bak, .trn) G:\Backup (Path where SQL Backup files are located)

B. SSRS Server :

ReportingServicesService.exe D:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin

C. Dynamics AX 2012 AOS Server :

Xppil folder C:\Program Files\Microsoft Dynamics AX\60\Server\AXPROD\bin\XppIL
Label files C:\Program Files\Microsoft Dynamics AX\60\Server\AXPROD\bin\Application\Appl

Thursday, October 22, 2015

Fix corrupt AX Install/Uninstall files using Microsoft Fixit


Got this error 1721 about Windows Installer when trying to do an uninstall of Dynamics AX 2012  R3 Client Visual Studio developer tools.


The fix was to use Microsoft Fixit to do a clean uninstall. Refer to the link below