Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 10:04 PM
Points: 52, Visits: 161
Hi,

There is version store size counter in transaction category of performance monitor

, and there is

version_store_reserved_page_count col in

dm_db_file_space_usage

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
http://technet.microsoft.com/en-us/library/ms175492(v=sql.105).aspx

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.


select

(max((user_objects_alloc_page_count-user_objects_dealloc_page_count)

+

internal_objects_alloc_page_count

-internal_objects_dealloc_page_count) * 8 ) * 1.0/128

from

tempdm_db_task_space_usage


yours sincerely

Post #1557313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse