Returns statistics for all objects and indexes with pages currently in a data cache.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
CacheID |
int |
Unique identifier for the cache |
|
ObjectID |
int |
Unique identifier for the object |
|
IndexID |
int |
Unique identifier for the index |
|
DBID |
int |
Unique identifier for the database |
|
OwnerUserID |
int |
Unique identifier for the database owner |
|
CachedKB |
int |
Number of kilobytes of the cache the object is occupying |
|
ProcessesAccessing |
int |
Number of processes currently accessing the object |
|
CacheName |
varchar(30) |
null |
Name of the cache |
DBName |
varchar(30) |
null |
Name of the database |
OwnerName |
varchar(30) |
null |
Name of the object owner |
ObjectName |
varchar(30) |
null |
Name of the object |
ObjectType |
varchar(30) |
null |
Object type |
