Try SentryOne free for 15 days and see how much easier your SQL tuning operations can be.
“One of my favorite things about Plan Explorer is the ability to copy the plan's XML and paste it in. When I'm working in client environments and they don't have PE installed, it's incredibly helpful.”
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.
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.