Provides a description of all monitoring tables. You can join monTables with monTableColumns for a description of each monitoring table and the columns it contains.
The metadata view for this table is identical for all instances in a shared-disk cluster.
You need not enable any configuration parameters for
this monitoring table to collect data.
The columns for monTables are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
1The Indicators column is a bit map. Use a bitmask to to determine which bits are turned on. A value of 1 indicates the table is a historical table. To display all tables that are historical: Select TableName from master..monTables where Indicators & 1 != 0 |
|||
TableID |
int |
Unique identifier for the table |
|
Columns |
tinyint |
Total number of columns in the table |
|
Parameters |
tinyint |
Total number of optional parameters you can specify |
|
Indicators |
int |
Indicators for specific table properties (for example, if the table retains session context)1 |
|
Size |
int |
Maximum row size (in bytes) |
|
TableName |
varchar(30) |
Null |
Table name |
Description |
varchar(368) |
Null |
Table description |
