Database Analysis

The Database Analysis module provides performance metrics for SQL statements. The module decodes Layer 7 SQL statements issued across the network to supported relational database servers. With these metrics you can analyze and evaluate how applications are performing in your network. For example, when an application is slow, is the problem in the network, the web server, the application server, or the relational database? While it isn’t unusual for the database to be the culprit, identifying and fixing a problem often requires detailed information about the SQL statements being used.

In addition to decoding the network traffic and isolating the SQL statements and their performance, AppResponse 11 also does a full parse of every SQL statement. It normalizes the statements across SQL dialects, enabling SQL statements to be standardized. In this process literals are masked out allowing the performance of a particular SQL statement to be compared over time, even when the statements originally looked different due to differing literals. For example, when the SQL statement "select customer_name where customer_id = 12345"is parsed, the literal “12345” is masked out (replaced by “L1”). This provides the additional benefits of hiding potentially sensitive information, such as SSNs or passwords, and improving AppResponse 11 performance and use of storage.