Post SQL Server Installation

Firewall considerations

Antivirus considerations

Configure your antivirus software settings and make sure that you exclude SQL Server binaries, backups and, above all, data files, transaction log files and the quorum disk (in a cluster configuration) from virus scanning.

Database considerations

It is also worth noticing that mixing different types of database implementations (i.e. OLTP vs. OLAP) is NOT recommended. OLTP databases usually have short transactions with a lot of updates whereas reporting databases, such as OLAP and data warehouse systems, have longer data-heavy queries.


M3 BE has mainly an OLTP performance profile. We strongly recommend NOT installing LBI/BPW database on the same instance and database server.