What types of databases can Foglight use for a FMS and SQL PI repository?
The Foglight Management Server (FMS) and SQL Server Performance Investigator (SQL PI) both require a database repository.
Foglight® Management Server requires a database repository. Users have the option of using either the embedded PostgreSQL® database included with Foglight®, or an external PostgreSQL, Oracle®, SQL Server®, or MySQL database. The embedded database is included with the Management Server and it follows the same lifecycle, it stops and starts with the server. If using an external database, the user is responsible for its procurement, installation, and management.
NOTE: For databases that have different editions, only the editions intended or licensed for production use are supported for use with Foglight. “Express” or “Lite” editions may be used to test Foglight, but should not be used in a production deployment.
As of the Foglight 5.9.8 release, the following database platforms are supported for use as Foglight Management Server (FMS) repository
Supported external databases
The Foglight FMS Database Repository can be configured using SQL Server Always On Availability Group for high availability on the back-end database. This only applies to SQL Server 2012 and above.
Other related KB articles
An Oracle Exadata Multi-Tenant CDB/PDB database configurations are also supported beginning with the 12c Oracle release (KB 229239)
Moving from the SQL Server Enterprise edition to SQL Server Standard Edition is supported (KB 181335)
Does Foglight support an unlicensed database edition as an external database repository? (KB 96951)
Where scripts be found to manually create a FMS repository database? (KB 310462)
What are the requirements if a SQL Server Database is create manually for a FMS repository? (KB 86090)
Supported FMS repository operating system versions
Users can run an external database on any operating system supported by the database vendor, but Quest only provides support for external database issues that can be reproduced on one of the operating systems (32- or 64-bit) listed in the following table.
|Red Hat Enterprise Linux|
|Microsoft SQL Server Version||Edition|
|Standard or Enterprise|
SQL Server 2017 on Linux and SQL Server 2019 on Linux have both been certified using a Linux OS beginning with the 18.104.22.168 and higher SQL Server cartridges.
NOTE: Support to install a PI repository on SQL Server Always On Availability Groups is described in KB 326158.
|Azure SQL Version|
Please refer to the following guides for the most current list of supported FMS and SQL PI repository database platforms