Since SolarWinds acquisition of Confio back in October, there have been some questions around a potential overlap between Database Performance Analyzer (formerly Confio Ignite), and SAM AppInsight for SQL. Although both products monitor SQL Server, Database Performance Analyzer and AppInsight for SQL are two very different products with entirely different purposes.
Database Performance Analyzer pinpoints the most significant database performance issues by using response time analysis. This is the time between the SQL query request and response that causes applications, and ultimately end-users, to wait. As the name Database Performance Analyzer implies, the primary objective is improving database performance, and Response Time Analysis is the best way to measure performance.
See the specific Wait Type in SQL Server that is causing the bottleneck
DPA users histograms (bar graphs) to identify the biggest issues, and within just 4 clicks you can drill down to the root cause by clicking on the big bars. By focusing on historical trends over time, database administrators and developers see the specific SQL Query, it’s response time, and the Wait Types, (discrete processing steps within SQL Server) causing the biggest impact on slow database response time.
Pinpoint problems with the SQL query + response time + specific Wait Type
AppInsight for SQL provides SQL Server performance visibility from the system resource perspective, isolating performance issues to SQL Server. This enables system administrators the ability to understand whether the performance issues are occurring due to resource contention, provisioning, or a slow query.
It all starts with discovery. By assessing your entire SQL Server inventory, you will be able to uncover the extent of the deployment. AppInsight for SQL provides a detailed hardware and software asset inventory. Just select the instances you are interested in for detailed health monitoring and alerting on both virtual and physical servers.
Monitor and alert on SQL Server health including logs and filesize
Since AppInsight is a module within System & Application Monitor (SAM) framework, in addition SQL Server health, you can monitor your entire application stack using the 150+ preconfigured application specific templates.