Another issue we are facing.
We have mount point, under the mount point, we have data1, data2, log1, log2, tempdbmdf1, tempdbmdf2, tempdblog1, tempdblog2,.....The tempdb's are pre-sized to say 20GB each, no auto growth set.
Out of the 20 GB, 15 GB is used for both tempdb...mdf's.
Getting ticket/alerts saying the tempdb is getting running out space. This has been going on for a while now.
Here are my questions.
I had told the AD team to try to fine tune their queries, try to minimize temp tables, temp variables, joins, etc, which will eat up a lot of tempdb space.
When does the tempdb release space? I know rebooting is one option.(not an option for me)
What else can you explain about tempdb use?
Anyone have script to find top 5 queries which will use a lot of tempdb space?
Anyway, if you don't mind can you guys share your experience with tempDB?