Temp DB – Part 1
| Legend | |
| 1 | Enhanced Chart of Total read activity over the selected time range of all TempDB files. |
| 2 | Enhanced Chart of Total write activity over the selected time range of all TempDB files. |
Temp DB – Part 2
| Legend | |
| 1 | TempDB table count distributions. There are five types: Global temp, regular temp, user table, system tables, and internal tables. |
| 2 | Enhanced Chart for wait events caused or affiliated with TempDB database:
PAGELATCH_DT – Caused when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Destroy mode. PAGELATCH_EX – Caused when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Exclusive mode. PAGELATCH_KP – Caused when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Keep mode. PAGELATCH_NL – Used for informational purposes only. PAGELATCH_SH – Caused when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Shared mode. PAGELATCH_UP – Caused when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Update mode. SLEEP_TEMPDBSTARTUP – Caused when a task waits for TempDB to complete startup. |