I’m looking for plans for a specific set of queries (those who replace MyTable
) utilizing sp_blitzcache
:
EXEC sp_Blitzcache @SlowlySearchPlansFor = 'UPDATE [My Table]'
this returns three outcomes, nevertheless, after I run the next question
SELECT d.title,
t.textual content AS TSQL_Text,
s.creation_time,
s.execution_count,
s.total_worker_time AS total_cpu_time,
s.total_elapsed_time,
s.total_logical_reads,
s.total_physical_reads,
p.query_plan
FROM sys.dm_exec_query_stats s
CROSS APPLY sys.dm_exec_sql_text(s.plan_handle) t
CROSS APPLY sys.dm_exec_query_plan(s.plan_handle) p
JOIN sys.databases d
ON t.dbid = d.database_id
WHERE t.textual content LIKE '%UPDATE [My Table]%' ESCAPE ''
it returns way more.
Is there some type of restrict in sp_blitzcache
round what queries are discovered? For instance, are low price queries ignored?