Skip to content
  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
LinkedIn Email
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

T-SQL: Top most used stored procedures

  • BartBart
  • February 11, 2019
  • SQL-Server

The code below will give you the top 10 most executed stored procedures in your database, sorted by execution count.

SELECT TOP 10 dest.text, deqs.execution_count,
deqs.total_worker_time, dest.objectid
FROM sys.dm_exec_query_stats deqs
CROSS APPLY sys.dm_exec_sql_text (deqs.sql_handle) dest
ORDER BY deqs.execution_count desc
Share your love
Bart
Bart
Articles: 100
T-SQL-Commands
Previous Post T-SQL: show uptime of SQL server & and status of agent
Next Post T-SQL: Find most I/O heavy SQL statements
T-SQL-Commands
No results

Recent Posts

  • Steam Deck: Hogwarts Legacy performance
  • T-SQL: Check cpu usage SQL statements
  • Steam Deck: Transfer files from Windows to Deck
  • PowerShell: Check TLS version
  • T-SQL: Identify queries that consume a large amount of log space

Archives

  • February 2023
  • December 2022
  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • SteamDeck
  • Uncategorized
Related Articles
T-SQL-Commands

T-SQL: Check cpu usage SQL statements

  • Bart
  • February 17, 2023
T-SQL-Commands

T-SQL: Identify queries that consume a large amount of log space

  • Bart
  • February 14, 2023
T-SQL-Commands

T-SQL: Shrink incremental

  • Bart
  • December 28, 2022

Copyright © 2023 Schelstraete.org

Add Schelstraete.org as app.

ADD