monTableColumns

Description

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.

You need not enable any configuration parameters for this monitoring table to collect data.

Columns

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)¹
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

¹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 2³², which can occur to 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
```