Sample Header Ad - 728x90

Issues with TempDB mdf file ever increasing

6 votes
2 answers
17523 views
I have a tempdb growth issue. Let me preface everything by giving my tempdb settings. tempdb settings Even with no queries running on the database/server tempdb keeps on increasing in size, at first rapidly and then slowly without stopping. I've run many queries to figure out what is running, below is the result of the query below which actually gave me the results I could use. dm_db_task_space_usage As can be seen they are all internal spid's is there any way to find out why tempdb continues to grow out of control and how to mitigate it? Any help on this problem would be greatly appreciated. --Query that returned the result set SELECT session_id, SUM(internal_objects_alloc_page_count) AS task_internal_objects_alloc_page_count, SUM(internal_objects_dealloc_page_count) AS task_internal_objects_dealloc_page_count FROM sys.dm_db_task_space_usage GROUP BY session_id HAVING SUM(internal_objects_alloc_page_count) > 0
Asked by nightmareivy (123 rep)
Jan 13, 2014, 07:56 PM
Last activity: May 7, 2020, 10:32 PM