Describes all the columns for each monitoring table. monTableColumns helps determine what columns are in the monitoring tables. You can join monTableColumns with monTables to report columns and column attributes for the monitoring tables.
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 monTableColumns are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
TableID |
int |
Unique identifier for the view |
|
ColumnID |
int |
Position of the column |
|
TypeID |
int |
Identifier for the datatype of the column |
|
Precision |
tinyint |
Precision of the column, if numeric |
|
Scale |
tinyint |
Scale of the column, if numeric |
|
Length |
smallint |
Maximum length of the column (in bytes) |
|
Indicators |
int |
Indicators for specific column properties (for example, if the column is prone to wrapping and should be sampled)1 |
|
TableName |
varchar(30) |
Null |
Name of the table. |
ColumnName |
varchar(30) |
Null |
Name of the column. |
TypeName |
varchar(20) |
Null |
Name of the datatype of the column. |
Description |
varchar(255) |
Null |
Description of the column (includes the column’s unit of measurement). |
Language |
varchar(30) |
Allows you to specify the language in which Adaptive Server returns the values of the Description column and the Label column. By default, Adaptive Server returns US English. Queries must use the the IS0-639 and ISO-3166 naming conventions. |
|
Label |
varchar(50) |
Description of the data presented in the column. You can use these values in application user interfaces instead of the actual column names. |
The Indicators column is a bitmap. Use a bit mask to to determine which bits are turned on. Possible values are:
1 – the value for Indicators may increase rapidly and lead to counter wrapping if values reach 232, which can occur in columns that have the number 1 bit in the Indicators column value turned on. To determine whether the 1 bit is turned on, use:
select TableName, ColumnName from Master..monTableColumns where Indicators & 1 != 0
2 – the counter is shared with sp_sysmon and is reset if you execute sp_sysmon. . .clear.
To display all columns sp_sysmon clears with the clear parameter, use:
Select TableName, ColumnName from master..monTableColumns where Indicators & 2 != 0