I am using express advance version of sqlserver 2008 r2,
Q1)is there any limitation of temp db , why i am asking is because rowversion uses it heavely.
What i have seen is, transactional data read by this sanpshot isolation level transaction will be around 200 mb to 500 mb and it changes 10 to 50 mb of data. which will complet in few mints or seconds . but the stored proc will be running continusally for 30 min to an hour ( it is sheduled on time basis ). and there is only one SP which will have snapshot isolation level transaction.
Q2) In sys.dm_tran_version_store ,
rowset_id is unique id for a record, or it can be given to a set of records as unique id?
q3) i have heard about 10 g restriction , so is it for each database, or it is for each instance?
yours sincerely.