SQL Server Performance

"trend micro" antivirus software

Discussion in 'SQL Server Clustering' started by icata, Apr 13, 2004.

  1. icata New Member

    Does any of you guys have used Trend Micro antivirus software in a cluster?
  2. bradmcgehee New Member

    No, but running any antivirus software directly on a cluster is risky. Generally speaking, Microsoft does not recommend it if you want to ensure the highest level of availability.

    As an alternative, you can install antivirus software on a non-cluster, and then use it to schedule daily file scans on the cluster. This is very safe, but does of course incur a performance hit during the file scan.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. icata New Member

    I don't get the difference. File locking will still occure and if the cluster will failover you will still have problems.
  4. Luis Martin Moderator

  5. satya Moderator

    As a general recommendation refrain using AV on cluster, especially.
    Even if you are not monitoring the shared disk, the filter drivers are still loaded and may affect the operation of the cluster.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. bradmcgehee New Member

    An outside virus scan will only scan closed files, which means the SQL Server data files will not be scanned, but as far as I know, there has never been a virus that has directly affected an open SQL Server data file. The scan is to catch viruses in more common files.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page