![]() , transaction_duration_s = datediff(s, tat.transaction_begin_time, sysdatetime()) , session_open_transaction_count = tst.open_transaction_count -uncommitted and unrolled back transactions open. , tat.transaction_id, tat.transaction_begin_time, tst.session_id In that case, the event_info field of sys.dm_exec_input_buffer will contain the last command string passed to the database engine. If the data returned by the text field of sys.dm_exec_sql_text is NULL, the request is not active but has an outstanding transaction.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |