Top SQL is a user interface that displays long-running and high-impact queries so you can easily troubleshoot SQL Server performance problems. With sortable grids, runtime charts, and index and
It’s no surprise that Top SQL is one of the most heavily utilized features in SentryOne: Monitoring and optimizing the queries executed against the SQL Server environment can have a profound impact on database performance.
SentryOne Plan Explorer helps you get to the root of the toughest SQL Server query problems by displaying query stats and history.
With Top SQL, you can list all T-SQL batches, stored procedures, and statement events collected for the current date range that exceeded the specified duration, CPU, or IO thresholds.
The query history chart visualizes your potentially troublesome queries framed hourly, daily, or weekly. You will see whether database queries show suspicious behavior at a glance. By drilling down on your query history, you can see the query duration, CPU consumption of each query, the number of reads and writes performed, and more.
You can even take a quick look at the query plan behind your query or procedure, and open, analyze, and optimize that plan with SentryOne Plan Explorer, a powerful feature that is built into the SentryOne Monitoring Platform and is also available as a free, standalone product.
“SentryOne helped me quickly drill down from Top SQL to the query plan and dashboard to evaluate performance and bottlenecks. It demonstrated for me that several of the SQL Servers were over allocated in resources.”