Tempdb storage on the disk
I'm working with SQL 2019 on-premises. lately due to an unoptimized query the size of tempdb spikes to around 49 GB and nearly 8 GB for each files group. now query is optimized and no longer spills to tempdb but we cannot fix the size of tempdb. I tried restarting the SQl server. I would like to ask whether this size is necessary and how can I reduce the size of tempdb.
