Deployment pre-requisites
Architecture
Deployment in Centralized vs Distributed
Hardware requirements
Supported monitoring platforms
Supported monitored databases
Supported monitored BI services
PI aggregation and retention
Permissions for monitored databases
Install the DB cartridge and DB agent
Special configurations
Permissions for Oracle databases
Permissions for SQL Server databases
Permissions for Sybase databases
Permissions for DB2 for LUW databases
Permissions for Azure SQL Database
Permissions for monitored operating systems
Supported monitored databases
Oracle Database 10g* — SQL PI supports version 11g and later
Operating Systems — All operating systems supported by the vendor.
Supported Editions — All editions supported by the vendor. Except for Sybase Edge and Runtime editions.
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.
Permissions for monitored databases
Ensure that you set the permissions required, based on which database you are using: