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