monTableColumns

¹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