Category : Plan Explorer - SentryOne Team Blog

Category: Plan Explorer

Latest Builds of SentryOne Software

Latest Builds of SentryOne Software

Latest builds of the SentryOne platform and Plan Explorer, as well as updated blog posts, downloads, and change lists.

Using Plan Explorer with Entity Framework

Using Plan Explorer with Entity Framework

Jason Hall gives a technical walk-through of one of his favorite use cases for Plan Explorer : troubleshooting application and Entity Framework code.

Plan Explorer – Fixes in the October 2017 Release

Plan Explorer – Fixes in the October 2017 Release

Product Manager for Plan Explorer, Aaron Bertrand, describes some of the enhancements in the October 2017 release of Plan Explorer.

Workarounds : Plan Explorer / SentryOne client won't maximize

Workarounds : Plan Explorer / SentryOne client won't maximize

Aaron Bertrand (@AaronBertrand) describes a few workarounds to a problem in Windows where an application won't respond to taskbar actions.

A few quick fixes for Plan Explorer

A few quick fixes for Plan Explorer

Aaron Bertrand (@AaronBertrand) describes four minor updates to SentryOne Plan Explorer in the latest build, 11.0.116.

Resolving Key Lookup Deadlocks with Plan Explorer

Resolving Key Lookup Deadlocks with Plan Explorer

Greg Gonzalez (@SQLsensei) uses Plan Explorer to walk through troubleshooting a very common type of deadlock : updates conflicting with key lookups.

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.

Plan Explorer 3.0 Demo Kit

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.