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

1 comment:

James Adrewson said...

Excellent piece of information,, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your blog gives the best and the most interesting information. This is just the kind of information that I had been looking for, I'm already your rss reader now and i would regularly watch out for the new posts, Thanks a lot!, Regards, AX consultant