Tempdb limt in sql express r2 2008 with respect to snapshot isolation level and sys.dm_tran_version_store detials

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply