Foglight for SQL Server (Cartridge) 5.9.2.1

Table 8. Supported Monitored BI Services
Integration Services*	Reporting Services*	Analysis Services
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.

Table 9. 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:

•

Permissions for Oracle databases

•

Permissions for SQL Server databases

•

Permissions for Sybase databases

•

Permissions for DB2 for LUW databases

Permissions for Oracle databases

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

Grant Select on the following dictionary views:


	NOTE: For Oracle 12c, replace all the dba_* dictionary views with the cdb prefix (cdb_*)

Table 10. Oracle views requiring Select permission
Dictionary view	Dictionary view	Dictionary view
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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

Foglight for SQL Server (Cartridge) 5.9.2.1 - Deployment Guide

Supported monitored BI services

PI aggregation and retention

Permissions for monitored databases

Permissions for Oracle databases