Monitor containers

You can view information about time series containers, such as the properties of containers, how large containers are, and how full containers are. If you monitor the containers over time, you can predict how quickly containers fill and how much data fits into each container.

To view information about the properties of containers, query the TSContainerTable table. For rolling window containers, view information about partitions in the TSContainerUsageActiveWindowVTI and TSContainerUsageDormantWindowVTI tables.

To view specific information about how full a container is, run one of the following functions, specifying the container name:

  • The TSContainerUsage function returns the number of pages that contain time series data, the number of elements, and the number of pages that are allocated to the container.
  • The TSContainerTotalPages function returns the number of pages that are allocated to the container.
  • The TSContainerTotalUsed function returns the number of pages that contain time series data.
  • The TSContainerPctUsed function returns what percent of the container is full.
  • The TSContainerNElems function returns the number of time series data elements that are stored in the container.

If you specify NULL instead of a container name, the functions return information about all containers in the database. If you include wildcard characters for the MATCHES operator in the container name, the functions return information about all containers that have matching names. For example, if your containers have a naming convention, you can monitor groups of contains that have similar names. For rolling window containers, you can specify which sets of partitions to view information about.