Page History
...
| Note |
|---|
The Tempdb Statistics report is available for users with monitored SQL Server instances on SQL Server 2005 or later. |
When to run this report
You should run the Tempdb Statistics report to view different space utilization and data throughput statistics currently occurring on your monitored SQL Server instances. This report allows you to obtain statistics through different metrics or chart types. Below a list of all possible metrics:
- Data File Size MB
- Data File Growth
- Reads Per Second
- Writes Per Second
- Transactions Per Second
- User Objects MB
- Internal Objects MB
- Version Store MB
- Mixed Extents MB
How SQL Diagnostic Manager calculates metric values on this report
Most values on the Tempdb Statistics report are averages of data from the system DMV sys.dm_db_file_space_usage on the monitored SQL Server.
...