Top SQL and Query Analysis
Optimize and tune SQL query performance
SQL Server query performance tuning should be easier
The Top SQL feature in SQL Sentry provides high-impact SQL query capture and analysis features. It collects details about running and completed queries, processes them for use in various features across the solution, and presents them for analysis, optimization, and tuning.
Top SQL becomes your guide to discovering the true root causes of poorly performing queries. Analyze your high-impact queries across the Microsoft Data Platform, including SQL Server, SQL Server Analysis Services (SSAS), and Azure SQL Database.
Troubleshoot using SQL Server wait stats with a 100-point scale score
With the addition of query level wait stats in the Top SQL dashboard in SQL Sentry Portal, users can understand wait times of their queries. With the ability to drill down into individual query, or view the totals waits to assist with troubleshooting and performance tuning opportunities.
Quickly identify the top resource-consuming queries over time and begin tuning them by analyzing top waits types such as WriteLog, CXPacket, and Async_Network_IO.
Execution plan diagram
With the integration of SQL Sentry Plan Explorer, you can view a graphical plan preview of the desired query in your environment.
This graphical representation of the query plan makes it easier to understand and identify performance bottlenecks by highlighting expensive operators, estimates, and actual row counts, allowing you to pinpoint areas that need optimization.
Compare SQL query history
Easily understand historical SQL query execution and find outliers in execution time. Query History displays a graphical representation of the selected query over a specified range of time. Query History provides information about the query execution plans, if they were changed, and how they impacted different resources.
Easily identify suspect statements that run thousands of times in a short period of time and subject your server to "death by a thousand cuts."
Get More on SQL Sentry Top SQL
Do you find yourself asking…
Why Top SQL?
The Pareto principle—commonly referred to as "the 80/20 rule"—is something most of us are likely familiar with. It generally holds true that 80% of one thing can be impacted or heavily influenced by 20% of another, related thing. In SQL Server terms, often 20% of the SQL queries running are responsible for 80% of performance concerns.
This 80/20 phenomenon is a primary reason SentryOne SQL query performance analysis and tuning begin with "Top SQL" rather than "All SQL." Top SQL is designed to quickly identify the 20% of your workload with the highest impact and resource-intensive queries. Tuning these queries first will greatly advance your journey from reactive to proactive. It can also free up time for you and your team to focus on the other 80% of queries. Incidentally, once you tune your highest impact queries, Top SQL will then surface the next round of your highest impact, resource-intensive queries, which will then become your focus for tuning.
Get started with Top SQL
SolarWinds SQL Sentry
- Fast root cause analysis
- Visibility across the data estate
- Deep, actionable performance metrics with easy deep-dive capabilities
Let’s talk it over.
Contact our team. Anytime.