anti-virus software

I'd like to hear if most people using anti-virus software
on the SQL production server? Also, what are the
performance implications of doing this?
TIA,
JB
JB,
I would recommend that you do not scan the SQL Server data or log file
directories, otherwise it should be OK. Depends on the anti-virus
product that you are using. I haven't had any problems with Sophos -
generally the anti-virus products these days are quite good, there used
to be stability and performance problems with them a few years ago. If
you had asked this question a few years ago I would have recommended you
don't install one, but I think it's OK now.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
JB wrote:
> I'd like to hear if most people using anti-virus software
> on the SQL production server? Also, what are the
> performance implications of doing this?
> TIA,
> JB
|||I agree with Mark, don't virus check your sql data and log files. At best it
can lead to performance problems...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OveS0WAlEHA.2500@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> JB,
> I would recommend that you do not scan the SQL Server data or log file
> directories, otherwise it should be OK. Depends on the anti-virus
> product that you are using. I haven't had any problems with Sophos -
> generally the anti-virus products these days are quite good, there used
> to be stability and performance problems with them a few years ago. If
> you had asked this question a few years ago I would have recommended you
> don't install one, but I think it's OK now.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> JB wrote: