Category: Plan Explorer

Aaron Bertrand provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer: Index Analysis.
Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
Jason Hall shows off some of the new features in a brand new update for Plan Explorer.
Aaron Bertrand explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.
Aaron Bertrand gives detail about an important enhancement in the latest release of SQL Sentry Plan Explorer, v2.7: better anonymization.
Aaron Bertrand shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.
Aaron Bertrand posts the slide deck and links from his recent presentation on SQL Sentry Plan Explorer at SQL Saturday #357 in Cleveland.
Paul White talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of...
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.

Top Categories

See all
1 2 3 4

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