Monitor Access to Executing SQL

Reports:

• Contention that occurs when sp_showplan accesses query plans.

  Querying monitoring tables (for example, monProcessSQLText and monSysSQLText) does not update these counters

• The number of overflows in SQL batch text buffers and the maximum size of SQL batch text sent during the sample interval