SentryOne Team Blog (blogs.sentryone.com)

Category: Plan Explorer

Performance Myths : Clustered vs. Non-Clustered Indexes

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

Rob Farley : Estimated Number of Rows to be Read

Rob Farley : Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

SentryOne Plan Explorer 3.0 Demo Kit

SentryOne Plan Explorer 3.0 Demo Kit

Last month we released the new, all-free, Plan Explorer 3.0 , and now seemed the right time to follow that up with the 3rd version of the demo kit, too.

Plan Explorer 3.0 Webinar – Samples and Q & A

Aaron Bertrand (@AaronBertrand) follows up a recent webinar on SQL Sentry Plan Explorer 3.0 with answers to about two dozen audience questions.

Plan Explorer PRO Goes FREE!

SQL Sentry CEO Greg Gonzalez (@SQLsensei) announces the completely free Plan Explorer 3.0, with two groundbreaking new features (Index Analysis and Performance Profiling).

Rob Farley : Plans with SQL Server 2016 Temporal Tables

For this month's T-SQL Tuesday, Rob Farley looks at some unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Announcing Plan Explorer Add-In Support for SSMS 2016

Aaron Bertrand (@AaronBertrand) reveals a new build of SQL Sentry Plan Explorer, updated to support the new add-in model introduced with the latest SSMS.

Rob Farley : What's "Actually" going on with that Seek?

Rob Farley (@rob_farley) digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.

Rob Farley : Actual Rows Read Warnings in Plan Explorer

Rob Farley (@rob_farley) looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.

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.

SQL Sentry v10 : Your world's about to get a whole lot bigger

With some homage to the Walking Dead, Jason Hall (@SQLSaurus) gives an interesting overview of some of the exciting functionality coming in SQL Sentry v10.

Bad cardinality estimates from SSMS plans – redux

Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.

#TipTuesday Contest

From now until March 14th, you can win a $250 Visa gift card just by tweeting your tips about SQL Sentry software. Rick Pittser explains #TipTuesday…

#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.