Category: Plan Explorer

Paul White looks at a couple of cases where - even though T-SQL is supposed to be a declarative language and any query that uses the...
Erin Stellato of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.
Aaron Bertrand provides links to his recent presentations (one with colleague Kevin Kline) at SQL Bits XII.
Erin Stellato of SQLskills shows how to use SQL Sentry Plan Explorer and SQL Sentry Performance Advisor to see automatic statistics updates.
Back in 2010, we first released SQL Sentry Plan Explorer, a free application for query tuning through deep but intuitive execution plan analysis. This post was created to provide a series of sample plans to help you learn the tool or to demonstrate it to others.
I wanted to talk about two new features in SQL Sentry Plan Explorer: Plan obfuscation, where you can hide sensitive information in your plans before sharing them, and custom layouts, a way to take complete control over the visual representation of your graphical plans.
The new version of Plan Explorer PRO 2.5 is focused on making these big plans easier to manage, and it does so using a variety of techniques that you have been asking for, which I will cover below.
It's hard to believe that we released the first version of Plan Explorer almost two years ago! The acceptance it has seen by the SQL Server community during that time has been amazing, and tremendously gratifying for all of us here at SQL Sentry.

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial