Things can go wrong in your database environment at any time—let’s face it, none of us work in a static environment. With 24/7 Azure monitoring, DPA can identify spikes in wait time behavior in a multi-dimensional way, making it easy to zero in on what’s causing the bottleneck and where it’s coming from. Database Performance Analyzer for SQL also watches for when behavior patterns change from what is expected, allowing you the ability to see the magnitude and alert based on sensitivities you can define.
Once you find the biggest problems, drill into the analysis that DPA provides to determine what’s causing the issues. Correlated resource metrics allow for insight into any utilization issues. Detailed blocking and deadlock analysis quantifies blocking impacts to end users and visualizes the blocking tree to see what sessions and queries were involved—who the culprit was and who the victims were. Query-level performance analysis brings all the available data into one view to answer, “Why is this query slow now?” and much more.
Finding and analyzing are great starts, but the ultimate goal should be to tune or reduce the effects moving forward. But there’s not always a silver bullet for inefficiencies. That’s why Database Performance Analyzer watches real workloads to highlight queries going after more data than they need. Those queries are aggregated at the table level so you can see best tuning and indexing opportunities at a holistic level. Often, simple changes make the biggest performance impacts—you just have to know where to look.
How do you know if your database tables are using best practices when you have multitudes of tables associated with your database? DPA’s table tuning best practices evaluate your table and indexes against a set of SQL Server performance tuning best practices. These include foreign key not indexed, overlapping indexes, wide index, table has no defined indexes, and table doesn’t have a primary key.
Database Performance Analyzer
Query and Table tuning advisors.
Monitors active sessions every second.
Multi-dimensional analysis isolates root cause of com