Provides statistics for all open local temporary databases, including global system tempdb when the instance is started in tempdb configuration mode. You must enable the object lockwait timing, enabling monitoring, and per object statistics active configuration parameters before monTempdbActivity can gather statistics.
Name |
Datatype |
Description |
|---|---|---|
DBID |
int4 |
Unique identifier for the database |
InstanceID |
tinyint1 |
ID of the instance within the cluster |
DBName |
varchar(30) |
Name of the database |
AppendLogRequest |
int4 |
Number of semaphore requests from an instance attempting to append to the database transaction log |
AppendLogWaits |
int4 |
Number of times a task waits for the append log semaphore to be granted |
LogicalReads |
int4 |
Total number of buffers read |
PhysicalReads |
int4 |
Number of buffers read from disk |
APFReads |
int4 |
Number of asynchronous prefetch (APF) buffers read |
PagesRead |
int4 |
Total number of pages read |
PhysicalWrites |
int4 |
Total number of buffers written to disk |
PagesWritten |
int4 |
Total number of pages written to disk |
LockRequests |
int4 |
Number of requests for a lock on the object |
LockWaits |
int4 |
Number of times a task waited for a lock for the object |
CatLockRequests |
int4 |
Number of requests for a lock on the system catalog |
CatLockWaits |
int4 |
Number of times a task waited for a lock for the system table |
AssignedCnt |
int4 |
Number of times this temporary database was assigned to a user task |
SharableTabCnt |
int4 |
Number of shareable tables created |
enable monitoring
per object statistics active
object lockwait timing
