TempDB activity
(TEMPDB)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| TEMPDB | string(32) | Name of tempdb |
| ASSIGNED_SPIDS | long | Number of processes assigned to the tempdb |
| USAGE_SPIDS | long | Number of processes currently using tempdb space |
| STATUS | string(12) | Database status (online, suspect, offline, quiesced, read only) |
| QUIESCETAG | string(32) | Quiesce tag for the database, if quiesced |
| SHAREDTEMPSIZE | double | Shared temp space used, in bytes |
| PRIVATETEMPSIZE | double | Private temp space used, in bytes |
| SYSLOGS | double | syslogs table space used, in bytes |
| WORKTABLESIZE | double | Worktable space used, in bytes |
| LOGICALREADS | double | Number of logical reads, since oldest data available |
| PHYSICALREADS | double | Number of physical reads, since oldest data available |
| PAGESREAD | double | Number of pages read, since oldest data available |
| PAGESWRITTEN | double | Number of pages written, since oldest data available |
| PHYSICALWRITES | double | Number of physical writes, since oldest data available |
| ROWSINSERTED | double | Number of rows inserted, since oldest data available |
| ROWSDELETED | double | Number of rows deleted, since oldest data available |
| ROWSUPDATED | double | Number of rows updated, since oldest data available |
| DROPLOGICALREADS | double | Internal-use number of logical reads on dropped objects; created by Surveillance |
| DROPPHYSICALREADS | double | Internal-use number of physical reads on dropped objects; created by Surveillance |
| DROPAPFREADS | double | Internal-use number of APF reads on dropped objects; created by Surveillance |
| DROPPAGESREAD | double | Internal-use number of pages read on dropped objects; created by Surveillance |
| DROPPHYSICALWRITES | double | Internal-use number of physical writes on dropped objects; created by Surveillance |
| DROPPAGESWRITTEN | double | Internal-use number of pages written on dropped objects; created by Surveillance |
| DROPROWSINSERTED | double | Internal-use number of rows inserted on dropped objects; created by Surveillance |
| DROPROWSDELETED | double | Internal-use number of rows deleted on dropped objects; created by Surveillance |
| DROPROWSUPDATED | double | Internal-use number of rows updated on dropped objects; created by Surveillance |
| DROPOPERATIONS | double | Internal-use number of operations on dropped objects; created by Surveillance |
| DROPLOCKREQUESTS | double | Internal-use number of lock requests on dropped objects; created by Surveillance |
| DROPLOCKWAITS | double | Internal-use number of lock waits on dropped objects; created by Surveillance |
| OPERATIONS | double | Number of operations on objects, since oldest data available |
| LOCKREQUESTS | double | Number of lock requests, since oldest data available |
| LOCKWAITS | double | Number of lock waits, since oldest data available |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| PHYSICALREADS_DELTA | double | Delta number of physical reads |
| LOGICALREADS_DELTA | double | Delta number of logical reads |
| LOGICALREADS_RATE | double | Number of logical reads per second, in interval |
| LOGICALREADS_RATE_AVG | double | Average number of logical reads per second per interval, since collection started |
| LOGICALREADS_RATE_MAX | double | Maximum number of logical reads per second per interval, since collection started |
| PHYSICALREADS_RATE | double | Number of physical reads per second, in interval |
| PHYSICALREADS_RATE_AVG | double | Average number of physical reads per second per interval, since collection started |
| PHYSICALREADS_RATE_MAX | double | Maximum number of physical reads per second per interval, since collection started |
| PHYSICALWRITES_RATE | double | Number of physical writes per second, in interval |
| PHYSICALWRITES_RATE_AVG | double | Average number of physical writes per second per interval, since collection started |
| PHYSICALWRITES_RATE_MAX | double | Maximum number of physical writes per second per interval, since collection started |
| PAGESREAD_RATE | double | Number of pages read per second, in interval |
| PAGESWRITTEN_RATE | double | Number of pages written per second, in interval |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |