The sp_iqcheckdb procedure can perform several different functions, depending on the parameters specified. The four modes for checking and repairing database consistency are described in “sp_iqcheckdb procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
You may run sp_iqcheckdb on any multiplex node, but on a secondary server the procedure cannot access the freelist so no freelist checks are performed.
A multiplex coordinator must be started in single node mode (-iqmpx_sn 1) in order to run sp_iqcheckb dropleaks. Dropleaks mode may be not run on multiplex secondary nodes.
