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 […]
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.
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 […]
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.
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 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: