-
Titre
What database platforms can be used as a Foglight repository (FMS and SQL PI)? -
Description
What types of databases can Foglight use for a FMS and SQL PI repository?
-
Cause
The Foglight Management Server (FMS) and SQL Server Performance Investigator (SQL PI) both require a database repository.
-
Résolution
Foglight Management Server 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.
Supported external databases
The list of supported database platforms for use as Foglight Management Server (FMS) repository varies by release. This is listed in the Supported external databases table in the System Requirements and Platform Support Guide document from our Foglight - Technical Documentation page in the Support Portal.
Other related KB articles
- Installing Foglight FMS repository on an Azure SQL Managed Instance (KB 4226446)
- An Oracle Exadata Multi-Tenant CDB/PDB database configurations are also supported beginning with the 12c Oracle release (KB 4289858)
- Moving from the SQL Server Enterprise edition to SQL Server Standard Edition is supported (KB 4259922)
- Does Foglight support an unlicensed database edition as an external database repository? (KB 4309110)
- Location of the scripts to manually create FMS repository database (KB 4226887)
- What are the requirements if a SQL Server Database is create manually for a FMS repository? (KB 4289507)
- Can a SQL Server Always On Availability Group be used for the FMS or SQL Server PI repository? (KB 4228629)
SQL Server PI Repository
The list of supported SQL Server® versions for use as PI (Performance Investigator) database repository may vary by release. This is included in the Foglight for Databases [version] Deployment Guide (e.g. "Foglight for Databases 6.3.0 Deployment Guide") document from our Foglight for Databases - Technical Documentation page in the Support Portal. This is listed under SQL PI Repository Instance section.
Documentation
Please refer to the following guides for the most current list of supported FMS and SQL PI repository database platforms.
- FMS Repository: Foglight System Requirements and Platform Support guide available for download from the Foglight Technical Documentation area in the Support Portal
- SQL Server PI Repository: Foglight for Databases deployment guide available for download from the Foglight for Databases Technical Documentation area in the Support Portal