DBCC_PINNABLE_CACHE_PERCENT Option

Controls the percent of the cache used by the sp_iqcheckdb system stored procedure.

Allowed Values

0 – 100

Default

50

Scope

Can be set for an individual connection or the PUBLIC group. Takes effect at the next execution of sp_iqcheckdb.

Description

The sp_iqcheckdb system stored procedure works with a fixed number of buffers, as determined by this option. By default, a large percentage of the cache is reserved to maximize sp_iqcheckdb performance.

Stored procedures are documented in Reference: Building Blocks, Tables, and Procedures.

For information on troubleshooting sp_iqcheckdb, see System Administration Guide: Volume 2 > System Recovery and Database Repair > Database Verification > Resource Issues Running sp_iqcheckdb.