Open object, index, and database usage

Each of these sections contains the same information for the three types of metadata caches. The output provides this information:

You can use this information to set the configuration parameters number of open indexes, number of open objects, and number of open databases, as shown in Table 39-2.

Table 39-2: Action to take based on metadata cache usage statistics

sp_sysmon output

Action

Large number of “Free” descriptors

Set parameter lower

Very few “Free” descriptors

Set parameter higher

“Reuse Requests Succeeded” nonzero

Set parameter higher

“Reuse Requests Failed” nonzero

Set parameter higher