question

trangle avatar image
trangle asked

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][1] on AdventureWorks2012 db using SQL Server 2012 . The issue occurs when I did the TRANSACTION ISOLATION LEVEL SNAPSHOT sample like this: ![alt text][2] 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][3] Anybody know about this issue? could you help me explain it? Thanks a lot !!! [1]: https://www.red-gate.com/simple-talk/sql/t-sql-programming/row-versioning-concurrency-in-sql-server/ [2]: /storage/temp/4249-capture.png [3]: /storage/temp/4250-capture2.png
t-sqlsql server 2012dba-developer
capture.png (15.6 KiB)
capture2.png (34.5 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
spiderdk avatar image
spiderdk answered
Hi Did you ever find out this one?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

trangle avatar image
trangle answered
Still not yet. :(
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.