QueryOperationPerformanceLogIndex

Since the QueryOperationPerformanceLog is a high-volume internal table, it has an associated index table that you can use to optimize administrative queries commonly performed against those tables: the QueryOperationPerformanceLogIndex. The Data Import Server produces this Index table as it imports data, making it possible to identify the set of internal partitions that have data for a given key.

Using the index table can significantly reduce the time it takes to query the QueryOperationPerformanceLog table, especially when you are looking for specific processes. See Indexing Intraday Partitions for more details.

Columns

NameDataTypeDescription
DateStringThe date of the event.
InternalPartitionStringThe column used to partition the table.
ProcessInfoIdStringThe unique identifier for the worker, used for correlating log entries and tables.
PrimaryAuthenticatedUserStringThe authenticated user that owns the worker.
PrimaryEffectiveUserStringThe effective user that owns the worker.
WorkerNameStringThe worker's name (e.g., worker_6baf6fae).
ServerHostStringThe host that the worker is executing on.