You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
863 lines
41 KiB
863 lines
41 KiB
[DA-ITSI-DATABASE-Database_Performance_KPIs]
|
|
title = Database: Performance
|
|
description = Performance KPIs for Database
|
|
source_itsi_da = DA-ITSI-DATABASE
|
|
_owner = nobody
|
|
kpis = [ \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_read_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, instance_read_iops, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 8877e62e74e3d4c01696da52)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance", \
|
|
"base_search_metric": "instance_read_iops", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "instance_read_iops", \
|
|
"object": "Performance", \
|
|
"owner_field": "Performance.instance_read_iops" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The number of reads per second to storage per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_read_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, instance_read_iops, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Read_IO/s", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "instance_read_iops", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_read_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, instance_read_iops, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 8877e62e74e3d4c01696da52)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_read_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, instance_read_iops, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Storage Read IOPS", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "ct/s", \
|
|
"urgency": "5" \
|
|
}, \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_write_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, instance_write_iops, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 99a6ad706d3fb7fefd6781d1)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance", \
|
|
"base_search_metric": "instance_write_iops", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "instance_write_iops", \
|
|
"object": "Performance", \
|
|
"owner_field": "Performance.instance_write_iops" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The number of writes per second to storage per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_write_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, instance_write_iops, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Write_IO/s", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "instance_write_iops", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_write_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, instance_write_iops, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 99a6ad706d3fb7fefd6781d1)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "instance_write_iops", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, instance_write_iops, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Storage Write IOPS", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "ct/s", \
|
|
"urgency": "5" \
|
|
}, \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "deadlock_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, deadlock_rate, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, ee66656040ee8338b118ab33)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance", \
|
|
"base_search_metric": "deadlock_rate", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "deadlock_rate", \
|
|
"object": "Performance", \
|
|
"owner_field": "Performance.deadlock_rate" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The number of deadlocks per second per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "deadlock_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, deadlock_rate, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Deadlock_Rate", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "deadlock_rate", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "deadlock_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, deadlock_rate, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, ee66656040ee8338b118ab33)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "deadlock_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, deadlock_rate, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Deadlock Rate", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "ct/s", \
|
|
"urgency": "5" \
|
|
}, \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "transaction_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, transaction_rate, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 5a92b0a1b54a832a6480d8ff)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance", \
|
|
"base_search_metric": "transaction_rate", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "transaction_rate", \
|
|
"object": "Performance", \
|
|
"owner_field": "Performance.transaction_rate" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The number of transactions per second per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "transaction_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, transaction_rate, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Transaction_Rate", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "transaction_rate", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "transaction_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, transaction_rate, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 5a92b0a1b54a832a6480d8ff)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "transaction_rate", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, transaction_rate, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Transaction Rate", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "ct/s", \
|
|
"urgency": "5" \
|
|
} \
|
|
]
|
|
|
|
[DA-ITSI-DATABASE-Database_Query_Log_KPIs]
|
|
title = Database: Query Log
|
|
description = Query Log KPIs for Database
|
|
source_itsi_da = DA-ITSI-DATABASE
|
|
_owner = nobody
|
|
kpis = [ \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "response_time", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance tag=query) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, response_time, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 2332a80fed439f803258c113)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance tag=query)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance_Query", \
|
|
"base_search_metric": "response_time", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "response_time", \
|
|
"object": "Query", \
|
|
"owner_field": "Performance.Query.response_time" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The average amount of time it takes for a query request to return a response per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "response_time", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance tag=query) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, response_time, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Query_Response_Time", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "response_time", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "response_time", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance tag=query) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, response_time, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 2332a80fed439f803258c113)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "response_time", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance tag=query) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, response_time, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Query Response Time", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "secs", \
|
|
"urgency": "5" \
|
|
} \
|
|
]
|
|
|
|
[DA-ITSI-DATABASE-Database_Network_KPIs]
|
|
title = Database: Network
|
|
description = Network KPIs for Database
|
|
source_itsi_da = DA-ITSI-DATABASE
|
|
_owner = nobody
|
|
kpis = [ \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connections", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, connections, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, bcd3d87b88d8bc19ecaac305)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance", \
|
|
"base_search_metric": "connections", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "connections", \
|
|
"object": "Performance", \
|
|
"owner_field": "Performance.connections" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The number of connections currently active per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connections", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, connections, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Active_Connection", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "connections", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connections", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, connections, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, bcd3d87b88d8bc19ecaac305)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connections", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, connections, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Active Connection", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "conn", \
|
|
"urgency": "5" \
|
|
}, \
|
|
{ \
|
|
"_owner": "nobody", \
|
|
"adaptive_thresholding_training_window": "-7d", \
|
|
"adaptive_thresholds_is_enabled": true, \
|
|
"aggregate_statop": "avg", \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": true, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connection_pool_used_percent", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, connection_pool_used_percent, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 26dd607b7555e27d454c95ae)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"alert_lag": "30", \
|
|
"alert_on": "both", \
|
|
"alert_period": "5", \
|
|
"anomaly_detection_alerting_enabled": false, \
|
|
"anomaly_detection_is_enabled": false, \
|
|
"anomaly_detection_sensitivity": 0.999, \
|
|
"anomaly_detection_training_window": "-7d", \
|
|
"backfill_earliest_time": "-7d", \
|
|
"backfill_enabled": false, \
|
|
"base_search": "(tag=database tag=performance)", \
|
|
"base_search_id": "DA-ITSI-DATABASE_Performance", \
|
|
"base_search_metric": "connection_pool_used_percent", \
|
|
"datamodel": { \
|
|
"datamodel": "Database", \
|
|
"field": "connection_pool_used_percent", \
|
|
"object": "Performance", \
|
|
"owner_field": "Performance.connection_pool_used_percent" \
|
|
}, \
|
|
"datamodel_filter": [], \
|
|
"description": "The percentage of the connection pool being used per database instance", \
|
|
"entity_alias_filtering_fields": "database_instance", \
|
|
"entity_id_fields": "database_instance", \
|
|
"entity_statop": "avg", \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": true, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connection_pool_used_percent", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, connection_pool_used_percent, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"gap_severity": "unknown", \
|
|
"gap_severity_color": "#CCCCCC", \
|
|
"gap_severity_color_light": "#EEEEEE", \
|
|
"gap_severity_value": "-1", \
|
|
"is_entity_breakdown": true, \
|
|
"is_service_entity_filter": true, \
|
|
"kpi_template_kpi_id": "DA-ITSI-DATABASE-Database_Connection_Pool_Used_%", \
|
|
"kpi_threshold_template_id": "custom", \
|
|
"search_alert_earliest": "5", \
|
|
"search_alert_entities": "", \
|
|
"search_buckets": "", \
|
|
"search_occurrences": 1, \
|
|
"search_type": "shared_base", \
|
|
"source": "", \
|
|
"target": "", \
|
|
"threshold_field": "connection_pool_used_percent", \
|
|
"time_variate_thresholds": true, \
|
|
"time_variate_thresholds_specification": { \
|
|
"policies": { \
|
|
"default_policy": { \
|
|
"aggregate_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connection_pool_used_percent", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_entity_time_series(avg, connection_pool_used_percent, database_instance, 5)` | `aggregate_entity_into_service_time_series(avg, 5)` | `assess_severity(DA-ITSI-DATABASE-DB_Monitoring, 26dd607b7555e27d454c95ae)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"entity_thresholds": { \
|
|
"baseSeverityColor": "#99D18B", \
|
|
"baseSeverityColorLight": "#DCEFD7", \
|
|
"baseSeverityLabel": "normal", \
|
|
"baseSeverityValue": 2, \
|
|
"gaugeMax": 100, \
|
|
"gaugeMin": 0, \
|
|
"isMaxStatic": false, \
|
|
"isMinStatic": true, \
|
|
"metricField": "connection_pool_used_percent", \
|
|
"renderBoundaryMax": 100, \
|
|
"renderBoundaryMin": 0, \
|
|
"search": "(tag=database tag=performance) `no_entities_matched` | `aggregate_raw_into_limited_entity_time_series(avg, connection_pool_used_percent, database_instance, 5)`", \
|
|
"thresholdLevels": [] \
|
|
}, \
|
|
"policy_type": "static", \
|
|
"title": "Default", \
|
|
"time_blocks": [] \
|
|
} \
|
|
} \
|
|
}, \
|
|
"title": "Database Connection Pool Used %", \
|
|
"type": "kpis_primary", \
|
|
"tz_offset": null, \
|
|
"unit": "%", \
|
|
"urgency": "5" \
|
|
} \
|
|
] |