SentryOne Team Blog (blogs.sentryone.com)

Category: 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.

Anonymize your plan details natively in Plan Explorer

Anonymize your plan details natively in Plan Explorer

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.

Plan Explorer PRO 2.5: Query plans your way

Have you ever worked with a query plan that was so large and unwieldy that it was next to impossible to make any sense of it? It can be a frustrating endeavor, for sure.

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.