Database Performance


Database performance management is the process of monitoring, analyzing and performing the subsequent performance tweaks of a database system in order to optimize performance and increase efficiency.


Business intelligence analysis techniques are also applied in order to monitor database performance, capture detailed data in a data warehouse and then mine these data for correlated problems and historical trends, and, in the process, expose anomalies or possible failure points.


Database performance can be defined as the optimization of resource use to increase throughput and minimize contention, enabling the largest possible workload to be processed. The core of the DBMS contributed to the performance speed equation.


Database performance monitoring is the act of measuring the performance of a given database in real time in order to determine problems and other factors that may cause problems in the future.


There are five factors that influence database performance: workload, throughput, resources, optimization, and contention. The workload that is requested of the DBMS defines the demand.