Skip to main content

Administration Appendices

Very specific detailed information is sometimes required for certain environment setups in Data Hub.

AntiVirus Exclusion recommendations for Data Hub and SQL​

When you configure your antivirus software settings, make sure that you exclude the following files or directories (as applicable) from virus scanning. Doing this improves the performance of the files and helps make sure that the files are not locked when the SQL Server service must use them.

Configure antivirus software to work with SQL Server

Because scanning may hinder performance, large databases should not be scanned. Since Microsoft SQL Server databases are dynamic, they exclude the directory and backup folders from the scan list. If it is necessary to scan database files, a scheduled task can be created to scan them during off-peak hours.

  • Directory - C:\Program Files\Zap Business Intelligence\Portal
  • Directory - C:\Program Files\Sage Data & Analytics\Portal
  • Directory - C:\Program Files\Zap Data Hub\Portal
  • Directory - C:\ProgramData\Zap Technology\Zap BI\Zap Data Hub
  • Directory - C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files
  • Directory - C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
  • Directory - C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config

SQL Database Engine and Analysis Services exclusions:​

  • File Type - *.mdf
  • File Type - *.ndf
  • File Type - *.ldf
  • Directory - ?:\Program Files\Microsoft SQL Server\MSAS*\OLAP\Data
  • Directory - ?:\Program Files\Microsoft SQL Server\MSAS*\OLAP\Log
  • Directory - ?:\Program Files\Microsoft SQL Server\MSAS*\OLAP\Temp
  • Process - SQLServr.exe
  • Process - MSMDSrv.exe