- 1 instance
Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.
Monitor query waits, sample SQL continuously, drill down into transaction analysis, view recommendation to improve queries, tune statement plans, and resolve locks and latches with the SQL Workload Analysis add-on. Isola