Enterprise Vault requires a number of SQL databases:
The Enterprise Vault Directory database holds the configuration information for an Enterprise Vault site.
Each vault store has a vault store database, which holds configuration information for the vault store and details of the items stored in its archives.
Each vault store group has a fingerprint database, which holds the fingerprints and other information related to the single instance storage parts that are created for Enterprise Vault single instance storage.
The Monitoring database holds monitoring information for the Enterprise Vault site.
If you configure FSA Reporting, Enterprise Vault creates an FSA Reporting database to hold the FSA Reporting data.
The SQL Server that manages these databases will typically reside on a different computer from the Enterprise Vault server.
In general, the specification of the SQL Server computer should match that of the Enterprise Vault server. The performance of the SQL Server will also benefit from extra memory; a minimum of 4 GB is recommended. The amount of memory that the SQL Server can use depends on the Windows and SQL Server versions.
Table: Minimum specification for SQL Server shows the recommended minimum specifications for a production SQL Server.
Table: Minimum specification for SQL Server
Item |
Recommended minimum |
---|---|
Number of CPUs |
2 |
Power of CPUs |
2.8 GHz |
Memory |
4 GB |
You do not need a separate SQL Server for every Enterprise Vault server. As a general rule, one SQL Server can manage up to eight Enterprise Vault servers.