Tools for measuring application performance or SQL database performance are readily available in the market today. They typically measure the performance of the application or the database but not both, and they cannot correlate database performance with application performance. SQL monitoring tools from Dynatrace, however, do provide this correlation in an end-to-end view of an application’s SQL performance.
Dynatrace is a leading APM application provider offering industry-best performance monitoring solutions for today’s multi-tier web applications. Dynatrace tools monitor application and SQL database performance for each application transaction starting from browser or client, to web server, to application runtime environments, to database server, and from the database server back to the browser or client. In addition to supporting traditionally popular application runtime environments like Java, Dynatrace also supports new technology monitoring like Nginx monitoring, Node.js monitoring, and Docker monitoring. The comprehensive performance monitoring and analysis functionality provided by Dynatrace tools empower many DevOps teams to detect and solve performance problems through the entire lifecycle of business critical applications.
Dynatrace provides powerful tools for monitoring SQL performance. These tools allow SQL monitoring at the application and database tiers and allow complete visibility into SQL performance in application transactions that span multiple tiers.
SQL monitoring tools at the application tier utilize Dynatrace’s patented PurePath Technology®. PurePath captures code-level and SQL statement-level detail and consolidates them with SQL query response times on dashboards for easy visualization. Captured data enables root-cause analysis to be carried out easily by tracking performance issues down to inefficient code and SQL queries. In the database tier, SQL monitoring tools facilitate SQL server monitoring by using a SQL monitor plugin for the SQL database. Plugins are available for widely deployed SQL databases such as Microsoft® SQL Server®, IBM® DB2®, and Oracle®. For databases that run in mainframes, Dynatrace SQL monitoring tools also capture SQL statements and the number of queries that are sent to these databases.
Captured performance data from a single tier often does not provide enough information to isolate a performance hotspot. Data from all tiers and components that participated in a transaction provides the best insights into application transaction performance. Network performance can also be a contributing factor to overall application performance. Hence, SQL monitoring tools can be supplemented with network performance tools such as Dynatrace Data Center RUM to offer insight into both database and network performance in the data center.
With Dynatrace Data Center RUM, the contribution of network performance to application and database performance and availability can be easily correlated. With metrics from all tiers and the network correlated by Dynatrace tools, your team can pinpoint and resolve performance and scalability bottlenecks faster than ever before.