How to capture SCANS from previous Diagnostics drilldown of Spotlight?
How to capture SCANS from previous Diagnostics drilldown of Spotlight? In version 11.7.1 the SQL Server Diagnostics has been deprecated in favor of the SQL Server | Workload Analysis drilldown CPU Resource. User used to use in version 11.1 feature to quickly get where SCANS exist in execution plans and then fix them with indexes. What feature to be used to find SCANS?
Enhancement request SOSSE-6059 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise to introduce the new Plan Visualization of SQL Activity drilldown.