Tag : execution plans - SentryOne Team Blog

Tag: execution plans

Adaptive Query Processing in SQL Server 2017

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really want to focus on is adaptive query processing. These new features speed processing of workloads, especially those that have historically been the

SQL Sentry v10 : Index Analysis

Aaron Bertrand (@AaronBertrand) provides some insight into a new feature in SQL Sentry v10, and coming soon to Plan Explorer : Index Analysis.

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.

Erin Stellato : Capture Execution Plan Warnings using Extended Events

Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.

Cool Features of SQL Server 2014: Improved Cardinality Estimates

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality

Statistics – What, why and how (Part 3)

Lori Edwards (@loriedwards) continues her series on SQL Server statistics, this time showing how even up-to-date statistics can yield inaccurate estimates.

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.

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.

It's Time to Go PRO!

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.

From the start we've had many requests for additional features and functionality. Many of those went directly into the free tool (for a full list go here). For others, it was obvious that some serious heavy lifting and/or an increase in the support requirements would be involved, making them not well-suited for a free tool.

Plan Explorer PRO is the result of many months of building out several of those high effort/high value features you've been asking for. Initially we've targeted the features that we believe will have the greatest impact on efficiency and information sharing. Here are the top 5 major features in PRO: