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. See “sp_iqversionuse procedure”.
DBA authority required. Users without DBA authority must be granted EXECUTE permission in order to run the stored procedure.
