The procedure outputs one row per table consuming RLV memory.
Output Column |
Description |
table_id |
ID of the table this row represents |
fragments |
number of store fragments for this table |
total |
total RLV memory used by this table |
data |
RLV memory used to store the table data |
dictionary |
RLV memory used to store the dictionaries for this table |
bitmap |
RLV memory used to store table level bitmaps |
Note: Version-specific data, such as version bitmaps and on-demand indexes,
do not count against the RLV memory limit and are not reported in
sp_iqrlvmemory. sp_iqrlvmemory accepts
optional parameters for owner name and table name which limit the output to a
single row.