RHOYLLE DBA Suite monitors TempDB with Automatic Restart Detection (ARD) and Resource Governor pools. TempDB is shared across all databases on an instance—keeping it healthy under load is critical.
What We Monitor
ARD helps detect when SQL Server restarts due to TempDB contention. Resource Governor pools let you isolate TempDB-heavy workloads. Our dashboard surfaces file count, size, and pool utilization.
PowerShell Script
Use our free script to check TempDB status on any instance. Compatible with RHOYLLE DBA Suite for integration into your monitoring pipeline.
.\Check-TempDB-ARD.ps1 -ServerInstance "PROD-SQL-01"
Download the script:
Check-TempDB-ARD.ps1 — TempDB ARD & Resource Governor monitoring
Check-TempDB-ARD.ps1 — TempDB ARD & Resource Governor monitoring
Run it against your instances to get file count, size (MB), and max memory. Use with RHOYLLE DBA Suite for automated alerts and dashboards.