TSQL Circle Live

Find Most executed queries

SELECT TOP 50
QueryState.execution_count
,OBJECT_NAME(objectid)
,query_text = SUBSTRING(
qt.text,
QueryState.statement_start_offset/2,
(CASE WHEN QueryState.statement_end_offset = -1
THEN len(convert(nvarchar(max), qt.text)) * 2
ELSE QueryState.statement_end_offset
END - QueryState.statement_start_offset)/2)
,qt.dbid
,dbname = db_name(qt.dbid)
,qt.objectid
FROM sys.dm_exec_query_stats QueryState
CROSS APPLY sys.dm_exec_sql_text(QueryState.sql_handle) as qt
ORDER BY...

2018-09-18

152 reads

Get all queries running against any specific table

/*Get list of all queries hitting any specific tables*/SELECT DISTINCT TOP 100ProcedureName = OBJECT_SCHEMA_NAME(sqlTxt.objectid) + '.' + OBJECT_NAME(sqlTxt.objectid),SQLStatement = SUBSTRING(sqlTxt.Text,(QueryState.statement_start_offset/2)+1,CASE QueryState.statement_end_offsetWHEN -1 THEN DATALENGTH(sqlTxt.text)ELSE QueryState.statement_end_offsetEND...

2018-09-18

145 reads

Blogs

SSMS Tip: Portable User Settings

By

I’m a creature of habit. With the software tools that I use, I like...

Schema evolution solved using Delta Lake & Databricks

By

Don’t know about you, but one of my least favourite data pipeline errors is...

SSMS Tip: Management Studio Script Projects

By

Did you know that SQL Server Management Studio can help you arrange your SQL...

Read the latest Blogs

Forums

Same DB, geographically diverse?

By SystemlordAnubis

Hi Everyone, I have a database (~50GB in size) with content that is constantly...

Updating Statistics

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Updating Statistics

SQL Server performance issue after an upgrade

By Kanishka Basak

Comments posted to this topic are about the item SQL Server performance issue after...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers