There is version store size counter in transaction category of performance monitor
, and there is
version_store_reserved_page_count col in
Q1) I wanted to know how should i compair/diffrencate them.
Q2) Please also tel me what is version store unit count in transaction category of counters of performace monitor.
Q3) "When tempdb runs out of space, the Database Engine forces the version stores to shrink."
above was written in following link
Does that mean shrinking is done automatically for other stores like object, internal objects etc in tempdb.
and finally i noticed i have to shrink it manully , please explain.
Q4) i have made a job(runs every 10 sec) and collected data from few miniuts in a table
to find the tempdb max usage , so that i can increment the auto grow accordingally.
please tel me is it correct.
-internal_objects_dealloc_page_count) * 8 ) * 1.0/128