eAutoClub, Inc.

            How to Exclude SQL Files from Anti-Virus to Prevent SI Slowdowns

            Symptoms:

            The ServiceIntelligence application or host machine suffers from system-wide slowdowns that affect the day to day usability of SI.

            About:

             Sometimes the server machine housing SI has active anti-virus programs that actively scan SQL databases for changes, since these files are large and constantly changing, they can be actively added back into the scanning queue by some anti-virus applications.

            Fix:

            1. Navigate to your Anti-virus file exclusion tool. Since this is unique for each anti-virus program, consult your anti-virus application's resources for specific instructions as to where this is.
            2. Add "sqlbrowser.exe" to the exclusion list. It is most commonly found in the "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn"directory.
            3. Add "sqlserver.exe" to the exclusion list. It is most commonly found in the "C:\Program Files\Microsoft SQL Server\90\Shared" directory.

            Note:

            If you cannot find the browser and server executables, a simple windows search of the C drive should yield the file locations to navigate to. 


            Updated: 19 Jul 2018 03:08 AM
            Helpful?  
            Help us to make this article better
            0 0