立即与支持人员聊天
与支持团队交流

Foglight for SQL Server (Cartridge) 5.9.7.21 - Deployment Guide

Supported monitoring platforms

Supported Platforms for the Foglight Management Server

http://support.quest.com/technical-documents/foglight/5.9.7/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.7/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 10g1

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

Amazon RDS for SQL Server2: 2012, 2014, 2016, 2017

Azure SQL Managed instance

Azure SQL Database

Azure SQL Database V12

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.53, 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

 

* 
NOTE:
1. Oracle Database 10g — SQL PI supports version 11g and later.
2. For the Amazon RDS for SQL Server, only Standard and Enterprise version are supported.
3. 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.

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级