Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. However I would still hope that everybody is familiar with using sys.dm_exec_requests
Plenty of new option popping up all over Management Studio get exploring.
Please Consider Subscribing