Sql server 2019, in this moment, is still in CTP.
There is a new DMF – sys.dm_exec_query_plan_stats , starting with 2.4CTP .
This DMF allow you to access the last execution plan, last ACTUAL execution plan for any query (with statistics). With out doing a thing(allmost).
You must have a trace flag activated – TF 2451 – which allows you to access light weight profiling tech. (No need to restart the instance)
More details are here.
S
Sql Server 