One of the main keys used for looking up an object in the cache. This is the object ID stored in sysobjects for database objects (procedures, views, triggers, and so on). For cache objects such as ad hoc or prepared SQL, objid is an internally generated value.

dbid

smallint

Database ID in which the cache object was compiled.

uid

smallint

Indicates the creator of the plan for ad hoc query plans and prepared plans. -2 indicates the batch submitted does not depend on implicit name resolution and can be shared among different users. This is the preferred method. Any other value represents the user ID of the user submitting the query in the database.

refcounts

int

Number of other cache objects referencing this cache object. A count of 1 is the base.

usecounts

int

Number of times this cache object has been used since inception.

pagesused

int

Number of memory pages consumed by the cache object.

setopts

int

SET option settings that affect a compiled plan. These are part of the cache key. Changes to values in this column indicate users have modified SET options. These options include: