Đoạn script tìm những long running transaction đang mở SELECT ST.transaction_id AS TransactionID ,DB_NAME(DT.database_id) AS DatabaseName...
Showing posts with label transaction. Show all posts
Showing posts with label transaction. Show all posts
11/10/2013
05/09/2013
Find uncommitted transaction
The T-SQL script to find uncommitted transaction SELECT SP.SPID,[TEXT] as SQLcode FROM SYS.SYSPROCESSES SP CROSS APPLY SYS.DM_EXEC_SQL_TE...
Subscribe to:
Posts (Atom)