Skip to content

Instantly share code, notes, and snippets.

@rodolfofadino

rodolfofadino/FindMostExecutedQueries.sql

Created October 9, 2017 18:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rodolfofadino/deb33fc019914e1bfbd8aa152aa090dc to your computer and use it in GitHub Desktop.
Save rodolfofadino/deb33fc019914e1bfbd8aa152aa090dc to your computer and use it in GitHub Desktop.
Download ZIP
Find Most Executed Queries
Raw
FindMostExecutedQueries.sql
SELECT TOP 50
qs.execution_count
,OBJECT_NAME(objectid)
,query_text = SUBSTRING(
qt.text,
qs.statement_start_offset/2,
(CASE WHEN qs.statement_end_offset = -1
THEN len(convert(nvarchar(max), qt.text)) * 2
ELSE qs.statement_end_offset
END
- qs.statement_start_offset)/2)
,qt.dbid
,dbname = db_name(qt.dbid)
,qt.objectid
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt
ORDER BY qs.execution_count DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment