Page History
The Tempdb Statistics report lets you view space utilization and data throughput statistics over time for your tempdb Tempdb database. You can focus on a single chart type, such as data file growth, and track its value increase over a specified period of time. This report allows you to obtain statistics through different metrics or chart types: 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, and Mixed Extents MB.
| 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:
...
...
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.
You can access our
| Newtablink | ||||
|---|---|---|---|---|
|
|
- How does SQL Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...