Guardian
TempDB contention detected · Only 1 data file on 16-core server · Recommend 8 files · Est. contention reduction: 85%
Files: 1 / 8 recommended
Version Store: 2.1 GB
Data Files
1
8 recommended
PFS Contention
HIGH
page free space waits
Allocated
14.2 GB
total size
Used Space
6.8 GB
current usage
Version Store
2.1 GB
RCSI / snapshot
Autogrowths
0
today
Data File Balance
1 FILE — CRITICAL
Contention Metrics
LIVE · 5s
Version Store
RCSI ACTIVE
34%
of TempDB
Version Store Size2.1 GB
Generation Rate12.4 MB/min
Cleanup Rate11.8 MB/min
Oldest Transaction18 min
Active Snapshots3
Top TempDB Consumers
BY SESSION
| Session | Login | Task Alloc (MB) | User Alloc (MB) | Wait Type |
|---|
Guardian Recommendations
3 URGENT