I’m being forced off of my powershell kick here for a few mins to talk about viruses.
Why do companies refuse to allow scanning exceptions for DB files? Do you really think that anyone’s written a SQL virus? I really can’t remember ever having see an actual virus that attacks SQL files. Actually, I take that back. There is one virus that attacks DB files and drags performance so far down you can barely use the system. In fact in my performance realm I actually classify this virus as an official DOS attack against my DB. It’s called virus scan. Virus scans are the only thing I’ve seen that specifically target DB servers to bring down the performance.
So if any of you non-SQL admins out there are running AV on your servers w/o exception policies for your DB files, turn yourselves in because you’re officially launching a DOS attack against your own servers.
But I promise I’m not bitter.
Do people really run virus scan on database servers? Damn
I’ve seen this in the wild. It’s usually the result of that ‘nobody in IT talks to each other’ syndrome or of the ‘shut up and take care of your database, DBA, stop bothering us admin people’ syndrome. Nasty business.