Does SQL Server Management Studio 2017 Contain a New Explain Feature
up vote
3
down vote
favorite
TL;DR I happened upon a feature in SQL Server Management Studio v17.9 which I was not aware of. It looks a bit like the EXPLAIN found in Oracle, PostgreSQL and MySQL. Where is this feature documented? How to Turn The Feature On I was running the following query with the options Include Actual Execution Plan (Ctrl + M) and Include Live Query Statistics turned on: SELECT sdes.session_id ,sdes.[status] ,sdes.login_name ,sdes.[host_name] ,sder.blocking_session_id ,sdb.name ,sdes.cpu_time ,sdes.logical_reads --optionally: + sdes.reads + sdes.writes ,sdes.last_request_start_time ,sdes.program_name ,sdes.session_id ,sder.request_id ,dest.[text] FROM sys.dm_ex