Category: Plan Explorer

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...
2 3 4 5 6

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