Find active queries that use a specific table

Home /Servicii baze de date/SQL Server/Find active queries that use a specific table
Home /Servicii baze de date /Find active queries that use a specific table

Find active queries that use a specific table

Data 16/09/2024
Autor Bogdan Dumitru
Categorie Servicii baze de date, SQL Server
2
185

Configurare noua (How To)

Situatie

Mai jos este o procedura ce listeaza toate queri-urile active ce folosesc o anumita tablea, care este primita de procedura drept parametru pe un server MSSQL.

Solutie

alter PROCEDURE FindActiveQueriesThatUseTableX_prc
@table varchar(max)

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

req.cpu_time,req.database_id,

req.total_elapsed_time

FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext where CHARINDEX(@table, sqltext.text) > 1

Tip solutie

Permanent

Etichetare: active queries that use a specific table

Voteaza

Up Down

(12 din 22 persoane apreciaza acest articol)

Follow Us