Monitors RLV store memory usage per table.
You must have EXECUTE privilege on the system procedure, as well as the MONITOR system privilege.
Version-specific data, such as version bitmaps and on-demand indexes, are not included in RLV memory accounting. They do not count against the RLV memory limit, and are not reported in sp_iqrlvmemory.
If no parameters are specified, information on all RLV tables consuming memory is returned. table_name, with the additional option of table_owner, can be provided to restrict the output to one table. If table_owner is not specified, it defaults to the current user.
| Column Name | Description |
|---|---|
| table_id | ID of the table this row represents. |
| fragments | Number of store fragments for this table. |
| total | Total RLV store memory, in MB, used by this table. |
| data | RLV store memory, in MB, used for the column fragments for this table. |
| dictionary | RLV store memory, in MB, used for the dictionaries for this table. |
| bitmap | RLV store memory, in MB, used to store table-level bitmaps. |
This example returns the current RLV memory usage for the table rlv_table1 owned by user DBA.
sp_iqrlvmemory ‘rlv_table1’, ‘DBA’
Output:
| table_id | fragments | total | data | dictionary | bitmap | |
|---|---|---|---|---|---|---|
| 1 | 778 | 1 | 1 | 0 | 1 | 1 |
| 2 | 779 | 1 | 48 | 48 | 0 | 1 |
| 3 | 785 | 2 | 1596 | 1584 | 0 | 12 |