Simple ways SQL tuning can benefit poorly performing databases

Tuning your SQL Server configuration as well as your queries is an important part of maintaining a SQL Server. Learn how SentryOne’s Performance Advisor can help!

Try Performance Advisor free for 15 days and see how much easier your SQL tuning operations can be.

Let's get started

SQL Tuning

“The more that I use SQL Sentry, the more I fall in love with it. #SQLSentry #LoveStory”

John Morehouse

Why Tuning Your SQL Server is Important

Why is tuning SQL Server and queries so important and necessary? You may notice queries are running slower than usual, jobs might be failing, or you may be seeing high CPU utilization. It’s important to know what is causing your resource bottlenecks. You want to know what is causing your biggest pain points, but where do you start? You can start searching for I/O bottlenecks and finding problem queries or creating indexes and partitioning tables. You can even add new hardware, but that may not solve the problem. All of these aspects of SQL tuning can be very daunting, but it doesn't have to be. SentryOne Performance Advisor offers a clear view of SQL Server performance issues to simplify SQL Server tuning.

  • Built in Performance Reports
  • Preconfigured & Custom Baselines
  • Side by side performance metrics
  • Visualize poor performing queries
  • Uncover storage & resource bottlenecks
  • System resource usage stats

Performance Advisor can make any DBA's job of SQL tuning easier. View all of your most pertinent SQL Server performance metrics side by side in the performance dashboard or with built-in performance reports. Performance Advisor includes several reports that are useful when tuning your SQL Server environment from wait stats analysis to global server performance. You can even run a report comparing date ranges for baselines of your server’s long-term performance.

Features for SQL Tuning

Baselines

Use preconfigured baselines, or custom baselines to quickly and easily discover your servers’ poor performing areas. Conveniently locate storage and I/O bottlenecks as well as system resource trouble areas all in one tool. With baselines, you can even pinpoint variations in server performance and begin SQL Server tuning efforts before you even experience performance issues.

Block Detection

With Performance Advisor's block analysis, you get a hierarchical display of all blocking processes which provides the most thorough picture of blocks occurring on your SQL Server. Wait resources are logically and efficiently resolved so that you can view the tables or indexes that are being contended for with no manual work.

Capture Deadlocks

Performance Advisor also allows you to quickly capture deadlocks in an easier to read format than native tools. Capturing these deadlocks enables you to identify processes and resources which were involved in the deadlock event. It can also determine which adjustments would have the largest impact and make the most sense when investigating SQL tuning options.

Integrated Plan Explorer Functionality

With integrated Plan Explorer functionality tuning SQL Server queries is even easier, with in-depth query plan analysis. Execution plans are collected for captured Top SQL statements as well as retained historically which allows you to view the performance impact of different versions. Plan Explorer also enables you to sort plans by highest cost operations to effortlessly see what plans may be leading to a performance problem, which can help you in your SQL Server tuning efforts.

SentryOne Performance Advisor offers many ways to track down performance issues and resolve them without wasting time and money. Visit our SQL Server Products page or check out “Performance Tuning the Whole Query Plan” by Paul White for more SQL Server tuning information. Want more information on SQL Server tuning? Find a SentryOne solution that is right for you.

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again