Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.7.5.5 - Deployment Guide

Supported Monitored Databases

 
Table 8. Supported Monitored Databases
Oracle
SQL Server
Sybase
DB2 for LUW
Oracle Database 10g*
Oracle Database 11g
Oracle Database 12c
Microsoft SQL Server 2005
Microsoft SQL Server 2008
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2012
Microsoft SQL Server 2014
Adaptive Server Enterprise:
12.5.1 through 16.0
 
Replication Server:
12.1, 12.5, 12.6, 15.0, 15.1, 15.2
DB2 version 9.5, 9.7, 10.1, 10.5
Oracle Database 10g* — SQL PI supports version 11g and above
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 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.
•
No additional permissions are required to monitor the Reporting Services.
 
Table 9. Supported Monitored BI Services
Integration Services*
Reporting Services*
Analysis Services
Microsoft SQL Server 2012
Microsoft SQL Server 2005
Microsoft SQL Server 2008
Microsoft SQL Server 2014
Microsoft SQL Server 2008
Microsoft SQL Server 2008 R2
 
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2012
 
Microsoft SQL Server 2012
Microsoft SQL Server 2014
 
Microsoft SQL Server 2014
 
*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 10. 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

Permissions for Monitored Databases

Ensure that you set the permissions required, based on which database you are using:
•
Oracle
•
SQL Server
•
Sybase
•
DB2 for LUW
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating