SentryOne Team Blog (blogs.sentryone.com)

Category: Plan Explorer

#BackToBasics : The "Runaway" Query

Aaron Bertrand (@AaronBertrand) describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.

Plan Explorer Update Just in "Time" for the New Year

Jason Hall (@SQLSaurus) shows off some of the new features in a brand new update for Plan Explorer.

Plan Explorer Support for SQL Server 2016

Aaron Bertrand (@AaronBertrand) explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.

Learning all about the SQL Server Plan Cache

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.

SQL Sentry Plan Explorer v2.7 : Better Anonymization

SQL Sentry Plan Explorer v2.7 : Better Anonymization

Aaron Bertrand (@AaronBertrand) gives details about an important enhancement in the latest release of SQL Sentry Plan Explorer, v2.7 : better anonymization.

Connecting SQL Sentry to a Different Domain

Aaron Bertrand (@AaronBertrand) shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.

SQL Sentry Plan Explorer Links

Aaron Bertrand (@AaronBertrand) posts the slide deck and links from his recent presentation on SQL Sentry Plan Explorer at SQL Saturday #357 in Cleveland.

Share What You Like Most About Plan Explorer and WIN!

UPDATE October 23, 2014 : We've selected a winner for our most recent SQL Sentry Plan Explorer PRO giveaway ($295 value).

Show Your Love For Plan Explorer and Win!

UPDATE September 25, 2014 : This contest for SQL Sentry Plan Explorer PRO (a $295 value) and a $50 Amazon gift card is now over – check out who won!

Paul White : Avoiding Sorts with Merge Join Concatenation

Paul White (@SQL_Kiwi) talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of attack.

Win a Plan Explorer PRO License from SQL Sentry!

UPDATE August 26th, 2014 : Our contest for a free license of SQL Sentry Plan Explorer PRO ($295 value) is now over; check out who won!

Erin Stellato : Considerations Around Column Order in Indexes and Sorts

Erin Stellato (@erinstellato) of SQLskills shows how sort operations can have a dramatic impact on plans, and what you can do about it.

Presentations from SQL Bits XII : T-SQL Bad Habits & Best Practices

Aaron Bertrand (@AaronBertrand) provides links to his recent presentations (one with colleague Kevin Kline (@kekline)) at SQL Bits XII in Telford, UK.

An Updated Plan Explorer Demo Kit

An Updated Plan Explorer Demo Kit

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.