sql server msde: like in the subject ...

can I expect any performance issues having an virus scanner installed
on the machine together with msde?

TIA

Stefan

hi Stefan,
[quoted text, click to view]

a similar question has been answered some time ago...
obviously AV activity can beat heavy loaded machines, but of course I do not
recommend not to install AV software... if possible just check for the less
intrusive one that fit your security requirements..
as regard SQL Server, it does not like other processes "check" it's data
files and you will usually define exceptions on them for all data files
(*.Mdf and *.Ndf) as long as for t-log files as well (*.Ldf)..
this will prevent AV software to scan those files for infections, but those
kind of files have never (actually till today) been virus target...
as regard performance issues, yes, you'll notice performance degradations
depending on the intrusive layer of AV scans, as AVs compete hard for system
resources and are intensive both on processors, I/O and ram...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply