TempDB grows silently until EVERYTHING slows.
✔ Fix: Right-size files
ALTER DATABASE tempdb MODIFY FILE (NAME='tempdev', SIZE=4GB);
And create multiple TempDB files:
4–8 files = massive improvement
💡 Why?
TempDB is used for:
-
joins
-
sorting
-
hashing
-
version store
This tweak alone boosts 90% of sluggish systems.