Chat now with support
Chat with Support

Foglight for SQL Server (Cartridge) 5.9.3.10 - Deployment Guide

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 2008

Microsoft SQL Server 2008 R2

Microsoft SQL Server 2014

Microsoft SQL Server 2016

Microsoft SQL Server 2017 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

*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:

Permissions for Oracle databases

If you are using Oracle®, ensure that these permissions are set.

Grant Select on the following dictionary views:

dba_constraints

dba_data_files

dba_db_links

dba_directories

dba_extents

gv_$session

gv_$session_wait

gv_$sort_segment

gv_$spparameter

gv_$sql

v_$logfile

v_$open_cursor

v_$osstat

v_$parameter

v_$pgastat

dba_free_space

dba_indexes

dba_jobs

dba_jobs_running

dba_libraries

gv_$sysstat

gv_$temp_extent_pool

gv_$undostat

obj$

recyclebin$

v_$pq_sysstat

v_$process

v_$recovery_file_dest

v_$resource

v_$result_cache_statistics

dba_objects

dba_profiles

dba_role_privs

dba_roles

dba_rollback_segs

ts$

uet$

user$

v_$archive_dest

v_$archived_log

v_$rman_status

v_$rowcache

v_$segstat

v_$segment_statistics

v_$sess_time_model

dba_scheduler_jobs

dba_scheduler_running_jobs

dba_segments

dba_sequences

dba_sequences

v_$asm_disk

v_$asm_disk_stat

v_$asm_diskgroup

v_$asm_diskgroup

v_$asm_diskgroup_stat

v_$session

v_$session_wait

v_$sesstat

v_$sga

v_$sga_dynamic_components

dba_synonyms

dba_sys_privs

dba_tab_columns

dba_tab_privs

dba_tables

v_$asm_operation

v_$asm_template

v_$cell

v_$controlfile

v_$database

v_$sgainfo

v_$sgastat

v_$spparameter

v_$sql

v_$sql_plan

dba_tablespaces

dba_temp_files

dba_temp_free_space

dba_undo_extents

dba_users

v_$datafile

v_$dataguard_status

v_$dbfile

v_$dispatcher

v_$enqueue_stat

v_$sqlarea

v_$sqltext_with_newlines

v_$standby_log

v_$statname

v_$sysmetric

dba_views

dba_recyclebin

fet$

file$

gv_$archive_dest

v_$enqueue_statistics

v_$event_name

v_$filestat

v_$fixed_table

v_$flash_recovery_area_usage

v_$sysstat

v_$system_event

v_$system_parameter

v_$tablespace

v_$temp_extent_pool

gv_$archived_log

gv_$instance

gv_$instance_cache_transfer

gv_$lock

v_$instance

v_$instance_cache_transfer

v_$iostat_file

v_$librarycache

v_$temp_space_header

v_$tempfile

v_$tempstat

v_$transaction

gv_$pq_sysstat

gv_$rman_configuration

gv_$rman_output

v_$lock

v_$log

v_$log_history

v_$undostat

v_$memory_target_advice

v_$pga_target_advice

v_$sga_target_advice

v_$sql_shared_cursor

gv_$archive_dest_status

gv_$dataguard_stats

gv_$dataguard_status

v_$flashback_database_log

v_$dataguard_config

v_$backup_set_details

v_$session_event

v_$services

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating