Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Tempb db size identification Expand / Collapse
Posted Tuesday, April 1, 2014 11:18 PM


Group: General Forum Members
Last Login: Sunday, October 16, 2016 10:43 AM
Points: 131, Visits: 301

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



yours sincerely

Post #1557313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse