Dec 23 2009
Installing Anti Virus on a SQL Server
It’s been quite a while since I last posted anything on this site, there’s been a lot of change behind the scenes and have a number of entries to post based on things that have happened in the last few weeks.
Earlier this week I was asked by one of our infrastructure guys when would be a good time to take down one of the servers and push out some new anti virus software using SMS (Server Management System) we arranged a suitable time where the no users would be affected but the real key issue as a DBA is to make sure that the anti virus software does not adversely affect performance.
There are differing schools of thought on whether anti virus should be applied or not because of performance reasons. If you are thinking about adding an AV solution to your SQL Servers or have already done so then please check the Microsoft KB article http://support.microsoft.com/kb/309422 to see what Microsoft recommends on this contentious issue.
RD 1st Feb 2013 – Microsoft have updated this document.
Richard Douglas
Richard is a Systems Consultant for a vendor of SQL Server solutions where he specialises in SQL Server providing solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site SQLServerPedia which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences. He is also a keen member of the SQL Server community, he founded and runs a PASS affiliated chapter in the UK (www.SQLStudy.org) and is on the organising committee for a national event called SQLRelay. Read more about Richard.
More Posts - Website
Follow Richard here:
