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
Deployment pre-requisites
Welcome to the Foglight for Databases Deployment Guide. This guide provides the pre-requisites for optimal deployment, to ensure the best user experience possible.
This section describes important deployment information required to monitor the leading RDBMS: Oracle®, SQL Server®, Sybase®, DB2 for LUW, and Azure® SQL.
Architecture
There are three main components:
|
• |
Foglight Management Server and Foglight Database Repository — Responsible for managing, alerting and viewing the collected data. Both components can be set to run on the same machine or reside on separate machines. |
|
• |
Agent Manager — Hosts the monitoring database agents. |
|
• |
SQL PI Repository — An embedded repository which stores the SQL PI data that the monitoring agents collect. Currently available on Oracle and SQL Server monitoring only. |
Figure 1. Foglight for Databases Components
Deployment in Centralized vs Distributed
Once the total number of agents exceeds 20, All-in-One installations are no longer supported.
