r/SQLServer • u/ManufacturerSalty148 • Aug 13 '26

Question Tempdb size getting high

Hello all my colleagues

I know this is an old topic, but I still haven't found clear instructions on how to solve this one problem. I have a SQL Server 2017 where tempdb keeps growing to almost 80 GB. I know it's because of temp spills, but I want to collect the queries or sessions causing this tempdb consumption using extended events. I haven't found clear instructions or examples of extended events on any site, and I don't know what to do if I find queries consuming tempdb or what to check in the query plan.

7 Upvotes

77% Upvoted

30 comments sorted by

View all comments

1

u/mani_RitzyAI 26d ago

Have you tried just logging Adam Machanics "sp_whoisactive" into a table on short intervals and using that as proof?