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”.
