ResourceUtilization

When a server selection provider is in use, the PersistentQueryController table logs resource utilization events in the ResourceUtilization table.

Columns

Column NameColumn TypeDescription
DateStringThe date on which the state change occurred. This is the partitioning column.
TimestampDateTimeThe timestamp of the event.
LoggingProcessNameStringThe process logging the event (usually PersistentQueryController).
ResourceProcessNameStringThe process name of the resource being tracked; this will be the dispatcher name.
HeapUsageMBintThe resource's current heap utilization in MB.
WorkerCountintThe resource's current worker count.
CommentStringA comment explaining the reason for the update, including a description of the worker where available. Valid reasons include:
  • Dispatcher connections or loss of connection
  • Internal notifications of starting persistent queries
  • Internal notifications of stopping persistent queries