syscacheobjects


Columns

Column Type Size Nulls Auto Default Children Parents Comments
bucketid int 4 null
cacheobjtype nvarchar 100 null
objtype nvarchar 40 null
objid int 4 √ null
dbid smallint 2 √ null
dbidexec smallint 2 √ null
uid smallint 2 √ null
refcounts int 4 null
usecounts int 4 null
pagesused int 4 √ null
setopts int 4 √ null
langid smallint 2 √ null
dateformat smallint 2 √ null
status int 4 √ null
lasttime bigint 8 √ null
maxexectime bigint 8 √ null
avgexectime bigint 8 √ null
lastreads bigint 8 √ null
lastwrites bigint 8 √ null
sqlbytes int 4 √ null
sql nvarchar 7800 √ null

Relationships

Close relationships within degrees of separation