| Author |
Topic |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2007-05-28 : 10:21:00
|
| Hi,Does a virus scanner has an impact on SQL Server performance? We saw an increase in execution time on jobs after the virus scanner is installed in a new server. The decrease of performance is not heavy, but it raised our curosity.We have excluded the following file types from scanning:mdf, ldf, ndf, bak, trnIs there any other file types missing in our exclusion list which is SQL Server related?Does anybody else having this issue?Thanks,Rushdi |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-28 : 10:23:43
|
in as much as the scanner will compete with sql server for I/O resources, it will degrade perf, seems to me.
www.elsasoft.org |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-28 : 10:27:07
|
| yes it will.don't install antivirus software on your db servers._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2007-05-28 : 10:30:15
|
| But, what about security? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-28 : 10:32:32
|
| you need to prevent viruses from getting to your db server before. with firewalls and proper access permissions tothe server._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-28 : 12:31:10
|
| Should skip db files from scanning at least. |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2007-05-31 : 10:40:44
|
| I exclude the MSSQL\DATA directory (or the directory where your .mdf .ndf .ldf files are located) from virus scanning. Our company policy will not allow any server to "turn off" virus protection for obvious reasons... |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-31 : 12:17:42
|
just excluding certain files and directories from scanning won't fix it completely, because AV software and SQL will compete for I/O resources.
www.elsasoft.org |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2007-05-31 : 13:56:10
|
| That is your choice. I would not want to explain to upper management why a production server became infected with a virus or trojan to save resources. At our company the extra CPU/IO is just part of doing business. We have had virus problems in the past; therefore, C.Y.A. baby! That is why they make faster hardware... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-31 : 13:58:56
|
| as i said... allowing the virus to infect the production db servermeans you have serious network security issues. i'd be looking into that._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
McAfee Virus Scanner and performance