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 FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLBinn

Full Text Index Catalog C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLFTData

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 FilesMicrosoft SQL ServerMSRS11.MSSQLSERVERReporting ServicesReportServerbin


C. Dynamics AX 2012 AOS Server :

Xppil folder C:Program FilesMicrosoft Dynamics AX60ServerAXPRODbinXppIL
Label files C:Program FilesMicrosoft Dynamics AX60ServerAXPRODbinApplicationAppl