Performance | tempdb | Overview

A summary of tempdb activity and usage.

Summary Metrics

What It ShowsComments
Total unallocated pages
Total allocated pages
% Space free
Active temp tables
Temp tables for destruction
Temp tables/sec
Workfiles/sec
Worktables/sec

Space Usage by File

A bar chart showing a breakdown of each tempdb file by page type.

What It ShowsComments
User objects
Internal objects
Version store
Mixed extents
< Performance | SQLOS | Schedulers Performance | tempdb | By Session >