Database performance software identifies bottlenecks and points of contention, monitors workload and throughput, and manages system and DBMS resource usage.
Ensuring that database systems perform effectively is a core requirement of modern IT management. There are several types of tools that can help database administrators and other IT professionals monitor, manage and improve the performance of databases and the applications that access them. But before you can consider whether you needÂ database performance software, it’s important to first definestyle=”color: database performance.
At a high level, database performance can be defined as the rate at which aÂ database management system (DBMS)Â supplies information to users. But to better understand what influences database performance, let’s examine the following five factors:
1.Â Â Â WorkloadÂ is the activity the DBMS is requested to perform, which drives the processing demands placed on the system. TheÂ workload can include a combination of transactions, batch jobs, ad hoc queries, reporting and analysis applications, database utilities and system commands. Workload can fluctuate drastically by day, hour or even minute. Sometimes it’s steady and predictable, but at other times it can spike, such as a heavy transaction workload on Black Friday for a database supporting a retailer’s e-commerce site.
2.Â Â Â Throughput is a measurement of a system’s ability to process data. It’s a composite of I/O and CPU speed, and it can be affected by the parallel capabilities of the database server and the efficiency of the operating system andÂ system software.
3.Â Â Â Resources are the hardware and software tools at the disposal of the system — such as database kernel, disk space, memory,Â cache controllers and microcode. The performance of accessing and modifying data in the database can be improved by the proper allocation and application of resources.
4.Â Â Â OptimizationÂ speeds up query performance. All types of systems can be optimized, butÂ relational databases are unique in that query optimization is primarily accomplished internal to the DBMS. Additional factors do need to be considered as well, including SQL formulation and database parameters, to enable the database optimizer to create the most efficient access paths.
5.Â Â Â Contention results when the demand for a particular system resource is high, for example, if two or more components of the workload are attempting to use a single resource in a conflicting way, such as dual updates to the same piece of data. As contention increases, throughput decreases.
So, database performance can be more accurately defined as the optimization of resource usage to increase throughput and minimize contention, enabling the largest possible workload to be processed.
What is for Sale
The market for tools can be split into three categories: The first is theÂ DBMS vendor market, which includes IBM, Microsoft and Oracle. These companies sellÂ software for their own DBMSs, as well as heterogeneous tools. The second category includes large ISVs and technologyÂ providers such as BMC, CA and Quest that sell database performance software as well as other categories of system software. The third category, niche database tools software vendors, includes companies that focus on database management and administration such asÂ Bradmark Technologies, Idera and SolarWinds.
These tools are typically sold directly to the customer and licensed by individual user, by database core or the size of the server being managed. Frequently, database performance tools are bundled with the database software as part of the initial DBMS acquisition.
Database performance software comprises a significant segment of the overall IT performance management software market. It provides many benefits, and there are numerous products to choose from. Which one do you choose?