Provides information about inmemory devices configured to store the contents of inmemory databases.
You need not enable any configuration parameters for this monitoring table to collect data.
monInmemoryStorage contains these columns:
Column name |
Type |
Description |
|---|---|---|
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
ID |
int |
ID of the data cache to which this device is bound. |
DeviceNum |
int |
Device number. Always -1 for inmemory devices. |
StartPage |
int |
Page ID for the first page in this device. |
NumPage |
int |
Number of pages in this device. |
SizeKB |
int |
Device size, in kilobytes. |
Name |
varchar(30) |
Name of the data cache for this device. |
DeviceName |
varchar(30) |
Name of the inmemory storage device. |
Type |
varchar(30) |
The type of storage. Always set to “cache”. |
Status |
varchar(30) |
Status of the device. |
