Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.5.20 - Deployment Guide

Supported monitoring platforms

Supported Platforms for the Foglight Management Server

http://support.quest.com/technical-documents/foglight/5.9.5/system-requirements-and-platform-support-guide/supported-platforms/supported-platforms-for-the-management-server

Supported Platforms for Foglight Agent Manager

http://support.quest.com/technical-documents/foglight/5.9.5/system-requirements-and-platform-support-guide/supported-platforms/supported-platforms-for-the-agent-manager

Supported monitored databases

 
Table 7. Supported Monitored Databases

Oracle®

Oracle Database 10g*

Oracle Database 11g

Oracle Database 12c

Oracle Database 18c

Oracle Database 19c

SQL Server®

Microsoft® SQL Server: 2005, 2008, 2008 R2, 2012, 2014, 2016

Microsoft SQL Server for Windows: 2017, 2019

Microsoft SQL Server for Linux: 2017, 2019

Microsoft SQL Server on Amazon RDS: 2016, 2017

SAP ASE®

Adaptive Server Enterprise: 15.x through 16.0

Replication Server: 15.0, 15.1, 15.2, 15.7, 16.0

DB2 for LUW

DB2 version 9.5*, 9.7, 10.1, 10.5, 11.1, 11.5

MongoDB®

2.4 and above

PostgreSQL®

9.1 and above

MySQL®

5.0 and above

MariaDB®

5.0 and above

Cassandra®

2.1 and above

Oracle Database 10g* — SQL PI supports version 11g and later

DB2 version 9.5* — Top SQL dashboard not supported

Operating Systems — All operating systems supported by the vendor.

Supported Editions — All editions supported by the vendor. Except for SAP Edge and Runtime editions.

* 
NOTE:
1. The SQL Server Azure managed instance is supported.
2. For the Amazon RDS SQL Server, only Standard and Enterprise version are supported.

Supported monitored BI services

•
The same user monitoring the SQL Server database engine must be used to monitor the Integration and Reporting Services.
•
The login ID used to monitor the Integration Service must be a user on the SSISDB database. This user ID is created while applying the “Grant permissions” script.
•
The ID used to monitor the Integration Services on the database needs to have:
•
the ssis_admin role in order to gather all needed information for its collections.
•
the db_datareader role on the SSISDB database.
•
Monitoring Analysis Services requires system administrator permissions on the Analysis Services instance.
•
Monitoring Analysis Services is supported only on Agent Managers running on Windows which must have a version of .Net 3.5 installed.
•
No additional permissions are required to monitor the Reporting Services.
 
Table 8. Supported Monitored BI Services
Integration Services*
Reporting Services*
Analysis Services

Microsoft® SQL Server® 2012

Microsoft SQL Server 2014

Microsoft SQL Server 2016

Microsoft SQL Server 2017 for Windows

Microsoft SQL Server 2019 for Windows

Microsoft SQL Server 2008

Microsoft SQL Server 2008 R2

Microsoft SQL Server 2012

Microsoft SQL Server 2014

Microsoft SQL Server 2016

Microsoft SQL Server 2017 for Windows

Microsoft SQL Server 2019 for Windows

Microsoft SQL Server 2008

Microsoft SQL Server 2008 R2

Microsoft SQL Server 2012

Microsoft SQL Server 2014

Microsoft SQL Server 2017 for Windows

Microsoft SQL Server 2019 for Windows

*SQL Server instance must be monitored to be able to monitor the service.

Operating Systems — All operating systems supported by the vendor.

Supported Editions — All editions supported by the vendor.

PI aggregation and retention

PI manages data using an internal time pyramid; the roll-up process runs every 15 minutes.

 
Table 9. Time pyramid table
Time resolution
Retention period

1 minute

6 hours

15 minutes

3 days

1 hour

2 weeks

6 hours

30 days

1 day

90 days

1 week

2 years

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating