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.

Fixes in Plan Explorer 18.4.5

Fixes in Plan Explorer 18.4.5

Product Manager Aaron Bertrand details the four fixes included in the latest release of SentryOne Plan Explorer (18.4.5).

Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).

New Deadlock Visualizations in SQL Sentry and Plan Explorer

New Deadlock Visualizations in SQL Sentry and Plan Explorer

Product Manager Aaron Bertrand gives a brief walk-through of the new deadlock visualization options in Plan Explorer and SQL Sentry.

Andy Mallon : Performance Myths : The query result cache

Andy Mallon : Performance Myths : The query result cache

Andy Mallon dispels the myth that SQL Server maintains some kind of query result cache to make future executions of the same query faster.

Features and fixes in Plan Explorer 18.4.2

Features and fixes in Plan Explorer 18.4.2

Product Manager Aaron Bertrand explains the fixes and enhancements in the latest release of SentryOne Plan Explorer (18.4.2).

Features and fixes in Plan Explorer 18.4

Features and fixes in Plan Explorer 18.4

The latest build of SentryOne Plan Explorer – 18.4.0 – is now available. Get a little insight behind the release notes from Product Manager, Aaron Bertrand.

T-SQL Tuesday # 101 – The BEST Index Analysis Solution

T-SQL Tuesday # 101 – The BEST Index Analysis Solution

Devon Leann Wilson highlights how the Index Analysis tab in SentryOne Plan Explorer helps with index creation for T-SQL Tuesday #101.

Webinar: Parameter Sniffing Using SentryOne

Webinar: Parameter Sniffing Using SentryOne

As a follow-up to Kimberly Tripp’s popular Parameter Sniffing webinar last week, SentryOne will present "Tackling Parameter Sniffing Using SentryOne" on Wednesday, January 31st at 2:00 – 3:00 PM EST.

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.