Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for Databases Shared 7.3.0 - Deployment Guide

Table of Contents

Deployment pre-requisites

Architecture Deployment in Centralized vs Distributed Hardware requirements

SQL PI configured All-in-One Installation SQL PI not configured Manual configuration requirement for SQL PI Repository

Supported monitoring platforms Supported monitored databases Supported monitored BI services PI aggregation and retention Permissions for SQL Server Based PI Repository Database Permissions for monitored databases

Permissions for Oracle databases

Additional configurations for Amazon RDS for Oracle instances

Permissions for SQL Server databases Permissions for SAP ASE databases Permissions for DB2 for LUW databases Permissions for Azure SQL Database

Permissions for monitored operating systems

Install the DB cartridge and DB agent

Install the DB cartridge Install a single DB agent

Install a single SQL Server or Oracle agent Install a single DB2 agent Install a single SAP ASE agent Install an Azure SQL DB agent

Special configurations

Foglight Upgrades High Availability Federation Concentrator (Proxy)

Supported monitoring platforms

Supported Platforms for the Foglight Management Server

http://support.quest.com/technical-documents/foglight/7.3.0/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/7.3.0/system-requirements-and-platform-support-guide/supported-platforms/supported-platforms-for-the-agent-manager

Supported monitored databases

Table 7. Supported Monitored Databases

Supported versions

Performance Investigator (PI)

Microsoft SQL Server: 2005 and above (Windows), 2017 and above (Linux)

Azure SQL Managed instance

Amazon RDS for SQL Server2: 2014 and above (If supported by Amazon)

SQL Server on Google Cloud Platform Version: 2017 and above (If supported by Google)

Azure SQL Database

Azure SQL Database

Oracle 11.2 and above

Supported on Windows, Linux, and on Amazon RDS

DB2 version 9.53, 9.7, 10.1, 10.5, 11.1, 11.5

Adaptive Server Enterprise: 15.x through 16.0

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

9.1 and above on Windows and Linux

Amazon RDS for PostgreSQL
Google Cloud SQL for PostgreSQL
Azure Database for PostgreSQL

•

10 and above on Windows and Linux

•

AWS RDS: 10 and above

•

•

Single server: 11

•

Flexible server: 11 and above

5.7 and above on Windows, Linux
Amazon RDS for MySQL

Azure Database for MySQL

Google Cloud SQL for MySQL

5.6 and above on WIndows Linux and Amazon RDS

Amazon Aurora compatible for MySQL and Postgress

10.0 and above
on Windows, Linux

Amazon RDS for MariaDB
Azure Database for MariaDB

10.0, 10.5 and above.on Windows and Linux

2.1 and above on Windows, Linux, and Azure

Managed instance for Cassandra was not tested

2.0 SPS 02 REV 20 and above

on Windows, Linux

Redis Enterprise 6.2 and above

on Windows, Linux and Azure


	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. 4. Foglight for Oracle supports monitoring the Amazon Relational Database Service (Amazon RDS™).

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

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center