RSA Scripts

Get cache queries

Get cache queries by a string that refer to specific text.

  1. Sql Server
  2. Cache
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

-- Adapted from demo scripts by Kimberly L. Tripp, SQLskills – https://www.sqlskills.com/blogs/kimberly/

CREATE PROCEDURE [dbo].[QuickCheckOnCache]
(
    @StringToFind   NVARCHAR (4000)
)
AS
SET NOCOUNT ON;

SELECT [st].[text]
    , [qs].[execution_count]
    , [qs].*
    , [p].* 
FROM [sys].[dm_exec_query_stats] AS [qs] 
    CROSS APPLY [sys].[dm_exec_sql_text] 
        ([qs].[sql_handle]) AS [st]
    CROSS APPLY [sys].[dm_exec_query_plan] 
        ([qs].[plan_handle]) AS [p]
WHERE [st].[text] LIKE @StringToFind
ORDER BY 1, [qs].[execution_count] DESC;
GO