Controls the percent of the cache used by the sp_iqcheckdb system stored procedure.
0 – 100
50
Can be set for an individual connection or the PUBLIC group. Takes effect at the next execution of sp_iqcheckdb.
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.
“sp_iqcheckdb procedure” in Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures
“Resource issues running sp_iqcheckdb” in Chapter 13, “System Recovery and Database Repair”in the System Administration Guide: Volume 2
Chapter 13, “System Recovery and Database Repair”in the System Administration Guide: Volume 1
