May 4, 2013 at 2:31 pm
Investigating on the use of tempdb with the following very simple query:
select convert(char(15), db_name(database_id)) as dbname
,transaction_id
,database_transaction_begin_time
,database_transaction_log_bytes_used
from sys.dm_tran_database_transactions
where database_transaction_log_bytes_used > 0
[/font]
dbname transaction_id database_transaction_begin_time database_transaction_log_bytes_used
--------------- -------------------- ------------------------------- -----------------------------------
tempdb 4078898703 2013-05-04 17:41:57.570 149539028
I can't find the owner session of transaction #4078898703
But with the following query:
SELECT
session_id
,connect_time
,last_read
,substring(text,1, 18)
FROM sys.dm_exec_connections
CROSS APPLY sys.dm_exec_sql_text (most_recent_sql_handle)
WHERE last_read between '20130504 17:40:00' and '20130504 17:42:00'
87 2013-05-04 17:41:56.170 2013-05-04 17:41:56.207 CREATE Procedure ...
The offending session is #87 (probably)
Why I can't find a reference to transaction #4078898703 in ALL the DMV?
May 6, 2013 at 5:44 am
I think this might be posted on Ask.SQLServerCentral too. But you want to use sys.dm_tran_session_transactions. That will let you get transactions for a session or a session for a transaction.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply