How to Configure Anti-Virus for SQL Servers

Roachlipication-Database

Oh, that’s not a virus! That’s just replication.

Anti-virus is a devilish beast. If you don’t implement it, someone’s sure to log onto your SQL Server and download some free tool that puts you at risk as soon as you’re not looking. If you do implement it, sometimes it can make you crazy.

And often it’s not even up to you: you need to follow corporate policy.

Here’s what you should know if you’ve got an anti-virus tool on your SQL Server.

Set the right Anti-Virus folder, file, and process exclusions

Good news: you don’t have take my word on what types of files and directories your anti-virus software should exclude. Microsoft lays it all out for you in KB 309422

Special cases: Keep outta my Address space

If you use any of the following products, read KB 2033238, “Performance and consistency issues when certain modules are loaded into SQL Server address space”:

  • McAfee VirusScan Enterprise
  • McAfee Host Intrusion Prevention
  • Sophos Antivirus
  • PI OLEDB provider

Virtualization Guests need staggered schedules

Scheduling matters. VMware recommends that you set anti-virus scans to run at non-peak hours in your guests, and to set scheduling so that multiple guests don’t all fire up burn all their resources at the same time on a single hosts.

Need proof? See page 41 in the Performance Best Practices for VMware vSphere® 5.5 Guide.

Windows Failover Clusters

Check out KB 250355 for special steps for Failover Clusters. (Thanks, Gary, for pointing out this has a bit more info than KB 309422 mentioned above!)

If you’re Running Anti-Virus, Run it in Pre-Production, too

Anti-virus isn’t just for production servers. If you run into any problems, you want to be able to check for a repro outside of production, too, right?

Previous Post
Doug Broke It: Minimal Logging [Video]
Next Post
New High Availability Planning Worksheet

14 Comments. Leave new

  • Some additional considerations if you have SQL Server Failover Cluster Instance:
    http://support.microsoft.com/kb/250355 (Antivirus software that is not cluster-aware may cause problems with Cluster Services)

    Reply
    • Kendra Little
      May 13, 2014 9:16 am

      Oh, good point. KB 309422 mentions excluding the cluster folder, but it doesn’t mention that temp directory. I’ll add a link to the article for that in case not everyone reads the comments– thanks!

      Reply
  • Lincoln Bovee
    May 15, 2014 3:35 pm

    A very useful post. We are running Sophos and were unaware of Sophos issue.
    Thanks Kendra!

    Reply
  • Derek Schoeters
    May 16, 2014 8:02 am

    Keep the cluster-exclusions in mind when installing Trend Micro’s Deep Security 😉

    Reply
  • Specifically for Sophos, I have all SQL Servers in their own OU then have a GPO for the SQL OU to set this registry key: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\SAVOnAccess]
    “ExcludedProcess0″=”SQLServr.exe”

    Additionally exclusions as described in KB 309422 are applied via Sophos policy settings.

    Reply
  • Anthony Douglas
    April 3, 2015 1:31 pm

    Great article

    Reply
  • Gene Torres
    April 3, 2015 2:43 pm

    How about the COM folder for snapshot.exe, etc for replication. I want to make sure replication processes are not intercepted by the antivirus. All those replication processes live in the COM folder, e.g.
    %ProgramFiles%\Microsoft SQL Server\100\COM all exe’s here in 2008 R2
    Or for SQL 2005
    %ProgramFiles%\Microsoft SQL Server\90\COM

    Reply
    • Kendra Little
      April 3, 2015 2:49 pm

      I haven’t heard of virus scanners causing problems with that, but I can’t think of a downside to excluding them, either.

      Reply
  • Kenneth Martin
    June 17, 2016 11:46 am

    Thank you for the article it added some much needed information about the Issues McAfee can cause.

    Reply
  • Any experience or recommendations with Palo Alto TRAPS on a SQL Server?
    or scanning SQL Servers?

    Reply
  • Ian Spencer
    May 3, 2019 6:56 am

    I have a list of SQL AV exclusions that are needed. Article has substituted the local Windows folder with %installdrive% and the SQL Server version with
    e.g.
    \Program Files\Microsoft SQL Server\.\Reporting
    Services\ReportServer\Bin\ReportingServicesService.exe
    Does it need the actual SQL Version 13.0.1305 or 2016 ?
    Help

    Reply
  • Peter Nauta
    June 3, 2019 6:05 am

    Another issue is with Datacollection: the cache files can get locked by Trend Micro Deep Security, memory usage can increase to 1,5GB RAM. On a 4GB RAM VM you will get memory exhaused errors (A significant part of sql server process memory has been paged out) and datacollection jobs may fail every now and then.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}