Load Test Comparison Charts and Reports

Comparing any two database loads in a changing environment can be complex. This is especially true in a load testing environment where many different scenarios are evaluated for performance and scalability. Being able to quickly see what has changed between the different scenarios is vital. This is where the AppDynamics for Databases load test comparison reports excel. They can immediately highlight where things have changed either positively or negatively saving you valuable analysis time.  

For example, you can see how things change within a specific time period as shown in the following chart:

and you can see how things have changed by comparing two time periods side by side as shown in the following report:

The Time Series Comparison Report gives a side-by-side comparison of two load tests, clearly showing the key performance indicators of each test along with the differences. It is easy to spot any change in CPU utilization, wait time or number of executions for each individual SQL statement as well as for the database instance overall.

The reports are not limited only to load testing and can simplify the task of comparing any two scenarios. For example you could compare a QA load with production, or compare two nodes of a cluster. Or you might want to compare a period of time before and after a change such as the addition of a new index.

Whatever your reason for using them, the AppDynamics for Databases charts and reports are real time savers.