Home Forums SQL Server 2005 SQL Server 2005 General Discussion Finding tempdb contention RE: Finding tempdb contention
SQL_Surfer
SSCrazy Eights
Points: 8318
More actions
December 7, 2013 at 9:17 pm
#1671745
Thanks. Which field should I look for heavy usage of tempdb?
user_objects_alloc_page_count?
Is there any threshold to indicate heavy usage?