sp_iqstatus Procedure

On a secondary server in a multiplex, this procedure also lists information about the shared IQ store and IQ temporary store.

If sp_iqstatus shows a high percentage of main blocks in use on a multiplex server, run sp_iqversionuse to find out which versions are being used and the amount of space that can be recovered by releasing versions.

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.