OK- so I noticed a big tempdb almost all of space is used by version store (from dmv information).
I ran dbcc opentran but found no old transactions.
I took a look at activity monitor and DID find some open tranactions which are "sleeping" and last batch
was about a week ago (open tranactions =1).
Why does DBCC Opentran not show these transactions- because they are "open" but not "active"?
These open trans are the likely reason for large version store size, correct?
See attached screenshot for example..