Deployment pre-requisites
Architecture
Deployment in Centralized vs Distributed
Hardware requirements
Install the DB cartridge and DB agent
Special configurations
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
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
Supported monitoring platforms
Supported Platforms for the Foglight Management Server
Supported Platforms for Foglight Agent Manager
Supported monitored databases
|
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 | |
|
DB2 version 9.53, 9.7, 10.1, 10.5, 11.1, 11.5 | |
|
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 ssis_admin role in order to gather all needed information for its collections. |
|
• |
the db_datareader role on the SSISDB database. |
|
Microsoft® SQL Server® 2012 |
*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.