Forum Discussion
MinhTran360
Jan 10, 2024Copper Contributor
How to get list of queries running against a table in the database?
Good Morning,
I am newbie and I would like to get your help?
I habve a table in a database , and it frequently got hit .
I would like to get a list of queries runng against my table, and their execution time.
Could you show me how to do it by giving a sql statement ?
Thank you so much,
To
- olafhelperBronze Contributor
MinhTran360 , SQL Server maintain some statistics about executions, like
sys.dm_exec_query_stats (Transact-SQL) - SQL Server | Microsoft Learn
Or Query Store: Monitor performance by using the Query Store - SQL Server | Microsoft Learn