SolarWinds® Database Performance Monitor (DPM) collects, analyzes, and visualizes metrics needed to help pinpoint Azure SQL performance issues in real time. DPM provides in-depth insight into Azure SQL database performance by monitoring latency, throughput, errors, warnings, index usage, execution plans, and more for every query executed. Designed by IT professionals for IT professionals, DPM is built to be intuitive and easy to use, allowing you to drill down from a global view to examine specific problem queries on individual servers with a few clicks.
DPM provides in-depth Azure SQL monitoring for system and infrastructure metrics in addition to Azure SQL metrics. DPM can also monitor and classify multidimensional data on queries, users, databases, and processes. Additionally, DPM can track disk usage, CPU, and other system components. DPM captures over 10,000 metrics every second, ensuring everything gets captured no matter how small. These features provide the powerful insights you need to quickly diagnose and solve performance problems with Azure SQL database in minutes, rather than hours or days.
DPM is a software as a service (SaaS)-based Azure SQL monitoring solution allowing you to quickly start monitoring and tuning your databases and queries. DPM helps you see quick ROI by saving you money on provisioning and maintenance costs while automatically offering access to new features and capabilities as SolarWinds deploys them.
The DPM agent auto-discovers your systems and installs quickly. This agent is completely passive, using techniques such as network traffic capture and system view inspections. They provide safe data encryption in flight and at rest, with no inbound network access required. The agents are also highly efficient, using less than 1% CPU.
Using big data analytics, DPM provides valuable insights into your database and system performance, helping you focus your troubleshooting efforts. The analytics platform in DPM uses advanced techniques such as regression analysis and queueing theory to deliver insight into the relationship between queries and system resources. Before and after comparisons, newly introduced queries, and tag functionality also help speed problem resolution.
Database performance can impact the entire organization. It’s essential to have database admins, system admins, application developers, and other team members working together to resolve performance problems. Chat integration, deep-linking, quick sharing, and other DPM features allow teams to share updates quickly and efficiently.
Database Performance Monitor
Monitor changes in database performance and the most important metrics
Work on Azure SQL analysis and optimization using a SaaS tool
Easily work in DevOps group with Azure SQL database performance analysis views