SQL Sentry - TOP SQL Overview
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 statistics analysis, you can quickly determine root cause, prioritize issues, and move on to the next problem.
Top SQL Feature Summary:
View all your queries by data range
Go back in time as far as three years
Specify the minimum duration or other criteria (e.g., CPU percentage or CPU time in milliseconds) for filtered queries
Drill down on any suspicious query for further information
Analyze your queries across your entire SQL Server environment and for each server instance
Jump between your Top SQL tab in SentryOne and other Performance Analysis views such as the Dashboard and Plan Explorer
Use Top SQL for analyzing your high-impact queries across the Microsoft Data Platform, including SQL Server, SSAS, and Azure SQL DB
Head over to https://www.sentryone.com/ to schedule a demo of SQL Sentry, learn more about TOP SQL, and download your free trial