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