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 minimum specified duration or a certain percentage of memory (CPU) or disk IO.
You can visualize your potentially troublesome queries within a specific time frame hourly, daily, or weekly, and see whether any of your filtered database queries show suspicious behavior. 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 on your screen at the query plan behind your query or procedure, and open, analyze, and modify 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.”