9 – How to Monitor TempDB

Now that we’ve got a good default setup for TempDB, and we understand what’s using it, let’s zoom out and ask a few big questions: Does TempDB have enough capacity? If not, what’s using space? Are the TempDB pages in memory fast enough? If not, do we need more files, and which queries are waiting...