Frequently Executed Queries

sp_BlitzCache™ Result: Frequently Executed Queries

Queries are being executed many times per second.

Even when these queries are lightweight, they still put load on the SQL Server.

Because you’re reading this, these queries are one of the top consumers of resources on your SQL Server. Fast running queries can be difficult to find with SQL Server Profiler or Extended Events; the most effective way to track these queries down is with the execution plan cache.

How to Fix the Problem

Stop running that query! Find a way to cache query results and avoid hitting the database altogether.

If your frequently executing queries are Scalar or Multi-Statement Table Valued Functions, consider rewriting them as Inline Table Valued Functions, replacing them with computed columns, or otherwise in-lining the code.

Find these queries by looking in the sp_BlitzCache™ output for queries with a high Executions / Minute value.

EXEC sp_BlitzCache @SortOrder = 'executions';

EXEC sp_BlitzCache @SortOrder = 'xpm';

EXEC sp_BlitzCache @SortOrder = 'executions';

EXEC sp_BlitzCache @SortOrder = 'xpm';