Area	Monitor element	Purpose
Disk Data
Logical Pages       Logical Size       Physical Size	COL_OBJECT_L_PAGES       COL_OBJECT_L_SIZE       COL_OBJECT_P_SIZE	Column-organized logical pages monitor element: The number of logical pages used on disk by column-organized data.   Column-organized data object logical size monitor element: Amount of disk space logically allocated for the column-organized data in the table, reported in kilobytes.   Column-organized data object physical size monitor element: Amount of disk space physically allocated for the column-organized data in the table, reported in kilobytes.
BUFFERPOOL
Page Reads	POOL_COL_L_READS         POOL_COL_P_READS         POOL_COL_LBP_PAGES_FOUND	Buffer Pool column-organized logical reads monitor element: This indicates the number of column-organized pages read in from the table space containers (physical) for temporary table spaces.   Buffer Pool column-organized physical reads monitor element: This indicates the number of column-organized pages read in from the table space containers (physical) for regular and large table spaces.   Buffer pool column-organized Local Buffer Pool pages found monitor element: This indicates the number of times that a column-organized page was present in the local buffer pool.
Page Writes	POOL_COL_WRITES	Buffer pool column-organized writes monitor element: This is the number of times a buffer pool column-organized page was physically written to disk
Asynch Reads / Writes	POOL_ASYNC_COL_READS         POOL_ASYNC_COL_READ_REQS         POOL_ASYNC_COL_WRITES         POOL_ASYNC_COL_LBP_PAGES_FOUND	Buffer pool asynchronous column-organized reads monitor element: Indicates the number of column-organized pages read in from the table space containers (physical) by a prefetcher for all types of table spaces.   Buffer pool asynchronous column-organized read requests monitor element: This is the number of asynchronous column-organized read requests by the prefetcher to the operating system.   Buffer pool asynchronous column-organized writes monitor element: This is the number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner, or a prefetcher.   Asynchronous local buffer pool column-organized pages found monitor element: This is the number of times a data page was present in the local buffer pool when a prefetcher attempted to access it.
Prefetch Requests	POOL_QUEUED_ASYNC_COL_REQS       POOL_QUEUED_ASYNC_COL_PAGES       POOL_FAILED_ASYNC_COL_REQS         SKIPPED_PREFETCH_COL_P_READS         SKIPPED_PREFETCH_UOW_COL_P_READS	Column-organized prefetch requests monitor element: This is the number of column-organized prefetch requests successfully added to the prefetch queue.   Column-organized page prefetch requests monitor element: This is the number of column-organized pages successfully requested for prefetching.   Failed column-organized prefetch requests monitor element: This is the number of times an attempt to queue a column-organized prefetch request was made but failed. One possible reason is the prefetch queue is full.   Skipped prefetch column-organized physical reads monitor element: This is the number of column-organized pages that an I/O server (prefetcher) skipped because the pages were already loaded into the buffer pool.   Skipped prefetch unit of work column-organized physical reads monitor element: This is the number of column-organized pages that an I/O server (prefetcher) skipped because the pages were already loaded into the buffer pool by an agent in the same unit of work.
Page Reads Table/Statement	OBJECT_COL_L_READS       OBJECT_COL_P_READS       OBJECT_COL_LBP_PAGES_FOUND	Column-organized logical reads monitor element: This is the number of column-organized pages that are logically read from the buffer pool for a table.   Column-organized physical reads monitor element: This is the number of column-organized pages that are physically read for a table.   Local buffer pool, column-organized pages found, monitor element: This is the number of times that a column-organized page for a table is present in the local buffer pool (LBP).
SQL
Statement	NUM_COLUMNS_REFERENCED	Number of columns referenced monitor element: This element counts the number of columns referenced during the execution of a section for an SQL statement.
Execution Times	TOTAL_COL_TIME         TOTAL_COL_PROC_TIME         TOTAL_COL_EXECUTIONS	Total column-organized time monitor element: This is the total elapsed time spent accessing columnar data in a query on column-organized tables. The value is given in milliseconds.   Total column-organized processing time monitor element: This is the total non-wait processing time spent accessing columnar data in a query on column-organized tables. The value is given in milliseconds   Total column-organized executions monitor element: This is the total number of times that data in column-organized tables was accessed.