This is the first time I add a topic here, but I recieve the SQLserverCentral Newsletter every week and find some topics very interesting. Thanks.
So I have the following issue on a SQL 2000 server protected by McAfee antivirus.
When McAfee is disabled, sqlserver.exe process uses less than 10% of the CPU
When I enabled McAfee, sqlserver.exe process jumps to about 60% of the CPU
It slows down the t-sql queries and some sql clients get timeout that affect client applications.
I opened a ticket to McAfee, but get no answer expected to install the last version. That is done but the issue remains.
Here are the McAfee exclusions:
BAK, LDF, MDF,NDF,TRN files
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP and subfolders
C:\Program Files\Microsoft SQL Server\MSSQL\Binn and subfolders
C:\Program Files\Microsoft SQL Server\MSSQL\Data and subfolders
C:\Program Files\Microsoft SQL Server\MSSQL\FTData and subfolders
D:\BACKUP and subfolders
D:\MSLSQL\Data and subfolders
D:\Tracability Manager and subfolders (databases are located in this directory)
Here are the McAfee Low Risk Process:
Agentsvr (SQL Agent)
Windows Server 2003 Standard Edition SP2 – intel Xeon 2 CPU 3,06GHz 4GO RAM (3GB swith)
SQL 2000 SP4
McAfee VirusScan Entreprise 8.7.0i
If someone has an idea ??