22-25 April 2026 
Actual
Proposed session for SQLBits 2026TL; DR
How to extract from a query plan the most interesting things in a simple and quick way? The answer: Actual 'spid51'. This is a stored procedure created by this author. It intercepts the statements executed by other spid (ex: spid51) and it returns the actual query plan plus many interesting informations.
Session Details
How to extract from a query plan the most interesting things in a simple and very quick way? The answer: Actual 'spid51'. This is a stored procedure created by me. It intercepts the statements executed by other spid and it returns the actual query plan, QueryHash, CardinalityEstimation, DOP, NonParallelPlanReason, StatementOptmLevel (Trivial, Full), StatementOptmEarlyReason , SettingsWrong: ANSI_NULLS , MissingIndexes, CreateIndex, Waittypes, CalculatedWaitTimeMs, Statistics, Warnings, GrantWaitTime, IsMemoryGrantFeedback and ParameterList used at first compilation (parameter sniffing).
3 things you'll get out of this session
Automatic query plan analysis
Intercept the activity from another spid (like SQL Profiler / Extender Events)