Provides statistics for all open local temporary databases, including global system tempdb when the instance is started in tempdb configuration mode. This monitoring table is available only for Adaptive Server Cluster Edition.
Set the enable monitoring, per object statistics active, and object lockwait timing configuration parameters for this monitoring table to collect data.
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 |