Splunk® IT Service Intelligence


This documentation does not apply to the most recent version of Splunk® IT Service Intelligence. For documentation on the most recent version, go to the latest release.

Database Module KPIs and thresholds

This topic provides detail on the Key Performance Indicators (KPIs) and the thresholds associated with those KPIs in the context of the ITSI Database Module. These KPIs impact the Health Score of the IT Service.

The default KPI calculation window for this module is Last 15 minutes, and calculation interval is Every 5 minutes. Adjust the search calculation interval for each supported add-on to match the five minute ITSI module calculation interval.

To adjust the search calculation time for this module:

  1. From the ITSI main menu, click Configuration > KPI Base Searches.
  2. Navigate to the KPI you wish to modify, and select Edit, followed by Clone.
  3. Name your cloned KPI base search and click Clone Page.
  4. Click on the KPI you wish to modify.
  5. Navigate to KPI Search Schedule, and select Every 5 Minutes from the dropdown menu.
  6. Click Save.

Database Module KPI Availability

The table below displays KPI availability based on the add-on that is used to collect data, and will display in its corresponding ITSI KPI swim lane.

KPI Name Microsoft SQL Server Add-on Oracle Add-on
Database Active Connection X X
Database Connection Pool Used% X X
Database Deadlock Rate X X
Database Query Response Time X X
Database Storage Read IOPS X X
Database Storage Write IOPS X X
Database Transaction Rate X X

KPI and Threshold Reference Table

KPI Name Description Unit Type Threshold Values
Database Active Connection The number of connections currently active per database instance. Count/Numeral Adaptive Thresholding Enabled
Database Connection Pool Used% The percentage of the connection pool being used per database instance. Percentage Adaptive Thresholding Enabled
Database Deadlock Rate The number of deadlocks per second per database instance. Deadlocks per second Adaptive Thresholding Enabled
Database Query Response Time The average amount of time it takes for a query request to return a response per database instance. Milliseconds Adaptive Thresholding Enabled
Database Server Storage Read IOPS The number of reads per second to storage per database instance. Reads per second Adaptive Thresholding Enabled
Database Server Storage Write IOPS The number of writes per second to storage per database instance. Writes per second Adaptive Thresholding Enabled
Database Transaction Rate The number of transactions per second per database instance. Transactions per second Adaptive Thresholding Enabled
Last modified on 27 June, 2023
Database Module configurations   Learn more about the Database Module

This documentation applies to the following versions of Splunk® IT Service Intelligence: 4.11.0, 4.11.1, 4.11.2, 4.11.3, 4.11.4, 4.11.5, 4.11.6, 4.12.0 Cloud only, 4.12.1 Cloud only, 4.12.2 Cloud only, 4.13.0, 4.13.1, 4.13.2, 4.13.3, 4.14.0 Cloud only, 4.14.1 Cloud only, 4.14.2 Cloud only, 4.15.0, 4.15.1, 4.15.2, 4.15.3, 4.16.0 Cloud only, 4.17.0, 4.17.1, 4.18.0, 4.18.1

Was this topic useful?

You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters