Created
January 10, 2014 11:23
-
-
Save yemrekeskin/8350375 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Açık olan transactionları listeler | |
SELECT L.request_session_id AS SPID, | |
DB_NAME(L.resource_database_id) AS DatabaseName, | |
O.Name AS LockedObjectName, | |
P.object_id AS LockedObjectId, | |
L.resource_type AS LockedResource, | |
L.request_mode AS LockType, | |
ST.text AS SqlStatementText, | |
ES.login_name AS LoginName, | |
ES.host_name AS HostName, | |
TST.is_user_transaction as IsUserTransaction, | |
AT.name as TransactionName, | |
CN.auth_scheme as AuthenticationMethod | |
FROM sys.dm_tran_locks L | |
JOIN sys.partitions P ON P.hobt_id = L.resource_associated_entity_id | |
JOIN sys.objects O ON O.object_id = P.object_id | |
JOIN sys.dm_exec_sessions ES ON ES.session_id = L.request_session_id | |
JOIN sys.dm_tran_session_transactions TST ON ES.session_id = TST.session_id | |
JOIN sys.dm_tran_active_transactions AT ON TST.transaction_id = AT.transaction_id | |
JOIN sys.dm_exec_connections CN ON CN.session_id = ES.session_id | |
CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS ST | |
WHERE resource_database_id = db_id() | |
ORDER BY L.request_session_id | |
--SPID ile açık olan transactionları KILL ediyoruz | |
--KILL SPID | |
KILL 285 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment