UpdatePerformanceLogCoreV2Index

Since the UpdatePerformanceLogCoreV2 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 UpdatePerformanceLogCoreV2Index. 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 UpdatePerformanceLogCoreV2 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 data.
ProcessInfoIdStringThe unique identifier for the worker, used for correlating log entries and tables.
WorkerNameStringThe worker's name (e.g., worker_6baf6fae).
ServerHostStringThe host that the worker is executing on.
PrimaryAuthenticatedUserStringThe authenticated user (e.g., the user who logged in via password, SAML, etc.) that owns the worker.
PrimaryEffectiveUserStringThe effective user (e.g., the "operate as" user if the authenticated user is using the "operate as" option) that owns the worker.