Situatie
Mai jos este un script care primeste ca parametru un nume de index si returneaza toate procedurile stocate / query-urile ce folosesc acel index.
Solutie
DECLARE @Index SYSNAME = N’NumeIndex’; — aici se pune numele indexului dorit
SELECT t.[text], s.execution_count, CONVERT(XML, p.query_plan)
FROM sys.dm_exec_query_stats AS s
CROSS APPLY sys.dm_exec_text_query_plan
(
s.plan_handle, s.statement_start_offset, s.statement_end_offset
) AS p
CROSS APPLY sys.dm_exec_sql_text(s.plan_handle) AS t
WHERE p.query_plan LIKE ‘%Index=”\[‘ + @Index + ‘\]”%’ ESCAPE ‘\’;
Leave A Comment?