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…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.

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...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}