A few times I’ve wondered how to detect the ISOLATION level and have discovered a few.
DBCC USEROPTIONS
DBCC USEROPTIONS
Set Option Value ——————————————————————————- textsize [...]
Tag Archives: dmv
More Snapshot dmv’s
Sunday, January 27, 2008
Following on from yesterdays post on sys.dm_tran_active_snapshot_database_transactions here is a look at four more dynamic management views that contain information about snapshot transactions.
sys.dm_tran_current_snapshot displays the transaction sequence number (XSN) for each transaction that was active when the current snapshot transaction started. sys.dm_tran_transactions_snapshot displays the all of the transactions with a XSN that were active when [...]
sys.dm_tran_active_snapshot_database_transactions and me
Saturday, January 26, 2008
I’ve worked out its impossible to just memorise all of the new Dynamic Management View and Functions in SQL Server 2005; so my new approach is to actually use one or two and see what they do.
According to the documentation for sys.dm_tran_active_snapshot_database_transactions it returns “a virtual table for all active transactions that generate or potentially [...]