Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.9.5.10 - Deployment Guide

Supported monitored databases

Oracle Database 10g*

Oracle Database 11g

Oracle Database 12c

Oracle Database 18c

Oracle Database 19c

Microsoft® SQL Server 2005

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 2017 for Linux

Microsoft SQL Server 2019 for Linux

Microsoft SQL Server 2012 on Amazon RDS

Microsoft SQL Server 2014 on Amazon RDS

Microsoft SQL Server 2016 on Amazon RDS

Microsoft SQL Server 2017 on Amazon RDS

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, 11.1

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

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.

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:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating