Which are different between XSN in dm_tran_active_snapshot_database_transactions and dm_tran_version_store?
Dear guys, I have a struggle when researching about row versioning. I did the exercise follow this site [link text] on AdventureWorks2012 db using SQL Server 2012 . The issue occurs when I did the TRANSACTION ISOLATION LEVEL SNAPSHOT sample like this: ![alt text] But when I monitor version record in DMVs (Dynamic managent view). Those Transaction sequence number (XSN) in dm_tran_active_snapshot_database_transactions different with XSN in dm_tran_version_store like this: ![alt text] Anybody know about this issue? could you help me explain it? Thanks a lot !!! :
https://www.red-gate.com/simple-talk/sql/t-sql-programming/row-versioning-concurrency-in-sql-server/ : /storage/temp/4249-capture.png : /storage/temp/4250-capture2.png