-
Title
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.
-
Resolution
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.
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
Database Supported Versions PostgreSQL - 9.5.x
- 9.6.x
- 10.x
- 11.x
- 12.x
- Amazon RDS PostgreSQL 9.5.x-12.x
- Amazon RDS Aurora PostgreSQL 9.6.x-11.x
MySQL - 5.6.18 or later on 5.6.x branch
- 5.7.9 or later on 5.7.x branch
- 8.x
Oracle - 11g R2 (11.2.x branch)
- 12x R1 (version 12.1.x branch)
- 12c R2 (version 12.2.x branch)
- 18c (version 12.2.0.2)
- 19c
SQL Server - SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- Amazon RDS SQL Server 2012-2019
- Azure SQL Managed Instance (KB 330986)
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.
Operating System Version HP-UX - 11i v3
IBM AIX - 5.3
Microsoft Windows - Server 2008 R2
- Server 2012
- Server 2012 R2
- Server 2016
- Server 2019
- 10
Oracle Solaris - 10 (Update 8)
- 11
Red Hat Enterprise Linux - 6.x
- 7.x
SQL Server PI Repository
Microsoft SQL Server Version Edition Standard or Enterprise - Microsoft SQL Server 2016 for Windows*
- Microsoft SQL Server 2017 for Windows
- Microsoft SQL Server 2019 for Windows
- Amazon RDS for SQL Server 2016*
- Amazon RDS for SQL Server 2017
* Microsoft SQL Server 2016 for Windows* - Requires SP1 or SP2 for SQL Server 2016 Standard edition.* Amazon RDS for SQL Server 2016* - Requires SP1 or SP2 for SQL Server 2016 Standard edition.SQL Server 2017 on Linux and SQL Server 2019 on Linux have both been certified using a Linux OS beginning with the 5.9.7.10 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 - Azure SQL Managed Instance (KB 330378)
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 of Supportlink
- SQL Server PI Repository: Foglight for Databases deployment guide available for download from the Foglight for Databases Technical Documentation area of Supportlink