Stores statistics for all tables, partitions, and indexes with pages currently in a data cache.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monCacheObject are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
CacheID |
int |
Unique identifier for the cache. |
|
InstanceID |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
||
DBID |
int |
Unique identifier for the database. |
|
IndexID |
int |
Unique identifier for the index. |
|
PartitionID |
int |
Unique identifier for the partition. This is the same value as ObjectID for nonpartitioned objects. |
|
CachedKB |
int |
Number of kilobytes of the cache the object is occupying. |
|
CacheName |
varchar(30) |
Null |
Name of the cache. |
ObjectID |
int |
Null |
Unique identifier for the object. Null if the descriptor for the object has been removed from the server’s metadata cache. In this situation, you can determine the object identifier by querying syspartitions in the specified database for the value of PartitionID. |
DBName |
varchar(30) |
Null |
Name of the database (NULL if the descriptor for the object was removed from the server’s metadata cache). |
OwnerUserID |
int |
Null |
Unique identifier for the object owner. |
OwnerName |
varchar(30) |
Null |
Name of the object owner (null if the descriptor for the object was removed from the server’s metadata cache). |
ObjectName |
varchar(30) |
Null |
Name of the object (null if the descriptor for the object was removed from the server’s metadata cache). |
PartitionName |
varchar(30) |
Null |
Name of the object partition (null if the descriptor for the object was removed from the server’s metadata cache). |
ObjectType |
varchar(30) |
Null |
Object type (null if the object is no longer open). |
TotalSizeKB |
int |
Counter, null |
Partition size, in kilobytes. |
ProcessesAccessing |
int |
Counter, null |
Number of processes currently accessing pages for this object in the data cache. |
