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.