Get TempDB Health
mssql_tempdb_healthEvaluates TempDB health by analyzing file layout, space usage, and top sessions, flagging issues like too few data files, unequal sizes, and percent autogrowth.
Instructions
TempDB health: file layout (count, equal sizes, autogrowth), space use (user objects, internal objects, version store, free space) and the top 10 sessions using tempdb. Flags too few data files, unequal sizes and percent autogrowth.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||