Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English
Read in English Edit
Twitter LinkedIn Facebook Email

Transaction Related Dynamic Management Views and Functions (Transact-SQL)

  • Article
  • 02/28/2023

In this article

Applies to: SQL Server

This section contains the following dynamic management objects.

sys.dm_tran_active_snapshot_database_transactions (Transact-SQL)

sys.dm_tran_current_snapshot (Transact-SQL)

sys.dm_tran_database_transactions (Transact-SQL)

sys.dm_tran_session_transactions (Transact-SQL)

sys.dm_tran_transactions_snapshot (Transact-SQL)

sys.dm_tran_version_store_space_usage

sys.dm_tran_active_transactions (Transact-SQL)

sys.dm_tran_current_transaction (Transact-SQL)

sys.dm_tran_distributed_transaction_stats (Transact-SQL)

sys.dm_tran_locks (Transact-SQL)

sys.dm_tran_top_version_generators (Transact-SQL)

sys.dm_tran_version_store (Transact-SQL)


Feedback

Was this page helpful?

Provide product feedback |
Get help at Microsoft Q&A

Feedback

Submit and view feedback for

This product This page
View all page feedback

Additional resources

California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2024

Additional resources

In this article

California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2024