Skip to content

Instantly share code, notes, and snippets.

@georgiyordanov

georgiyordanov/search_query_plan_cache.sql

Created February 10, 2020 13:10
Show Gist options
  • Save georgiyordanov/b15c3c37a2f40949ef8069a9f0e0e34e to your computer and use it in GitHub Desktop.
Save georgiyordanov/b15c3c37a2f40949ef8069a9f0e0e34e to your computer and use it in GitHub Desktop.
Download ZIP
Search the SQL Server query plan cache
Raw
search_query_plan_cache.sql
SELECT
databases.name,
dm_exec_sql_text.text AS TSQL_Text,
dm_exec_query_stats.creation_time,
dm_exec_query_stats.execution_count,
dm_exec_query_stats.total_worker_time AS total_cpu_time,
dm_exec_query_stats.total_elapsed_time,
dm_exec_query_stats.total_logical_reads,
dm_exec_query_stats.total_physical_reads,
dm_exec_query_plan.query_plan
FROM
sys.dm_exec_query_stats
CROSS APPLY sys.dm_exec_sql_text(dm_exec_query_stats.plan_handle)
CROSS APPLY sys.dm_exec_query_plan(dm_exec_query_stats.plan_handle)
INNER JOIN sys.databases
ON dm_exec_sql_text.dbid = databases.database_id
WHERE
dm_exec_sql_text.text LIKE '%Absence%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment