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:
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)
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
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
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
ReplyDelete