It will applicable for MSSQL7.0 , 2000 , 2005, 2008 , Windows NT Server 4, Windows Server 2000 & Windows Server 2003.
Anti-virus activity can cause can cause performance degradation and data corruption.
The following are the some of few possible issues.
1. SQL Server file system can potentially cause high disk utilization.
2. High CPU spikes or High CPU usage .
3. On cluster environment you may get resource failure problems when you try to move a group to different node.
4. Access denied to SQL Server files.
5. Originate stop errors on Windows Server.
To over come these issues you need to do exclusions from Virus Scanning
Exclude windows paging file such as edb*.log , rest1.log , rest2.log,edb.chk,tmp.ed,pagefile.sys
Exclude the spool directory i.e %systemroot%\System32\Spool ) and subfolders
Exclude *.mdf,*.ldf,*.ndf from virus scanning activity.
Exclude database backup and transaction log backup files.
Exclude SQL Server directories \Program Files \ Microsoft SQL Server
Exclude folders related to windows update i.e %systemroot%\softwaredistribution\datastore and its subfolders .
Additional exclusions on Cluster are :
Exclude the quorum drive
Exclude the \MSDTC directory in the MSDTC share drive.
Exclude the %sytemroot%\Cluster directory
Temp Folder for the Cluster Service Account.
Anti-virus activity can cause can cause performance degradation and data corruption.
The following are the some of few possible issues.
1. SQL Server file system can potentially cause high disk utilization.
2. High CPU spikes or High CPU usage .
3. On cluster environment you may get resource failure problems when you try to move a group to different node.
4. Access denied to SQL Server files.
5. Originate stop errors on Windows Server.
To over come these issues you need to do exclusions from Virus Scanning
Exclude windows paging file such as edb*.log , rest1.log , rest2.log,edb.chk,tmp.ed,pagefile.sys
Exclude the spool directory i.e %systemroot%\System32\Spool ) and subfolders
Exclude *.mdf,*.ldf,*.ndf from virus scanning activity.
Exclude database backup and transaction log backup files.
Exclude SQL Server directories \Program Files \ Microsoft SQL Server
Exclude folders related to windows update i.e %systemroot%\softwaredistribution\datastore and its subfolders .
Additional exclusions on Cluster are :
Exclude the quorum drive
Exclude the \MSDTC directory in the MSDTC share drive.
Exclude the %sytemroot%\Cluster directory
Temp Folder for the Cluster Service Account.
No comments:
Post a Comment