ServerStateLogIndex
Since the ServerStateLog 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 ServerStateLogIndex. 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 ServerStateLog table, especially when you are looking for specific processes. See Indexing Intraday Partitions for more details.
Columns
| Name | DataType | Description |
|---|---|---|
Date | String | The date of the event. |
InternalPartition | String | The column used to partition data. |
ProcessUniqueId | String | The unique identifier for the worker, used for correlating log entries and tables. |
AuthenticatedUser | String | The authenticated user that owns the worker |
EffectiveUser | String | The effective user that owns the worker. |
Related documentation
- Internal tables overview
AuditEventLogPersistentQueryConfigurationLogPersistentQueryStateLogProcessEventLogIndexProcessEventLogProcessInfoProcessMetricsQueryOperationPerformanceLogIndexQueryOperationPerformanceLogQueryPerformanceLogQueryUserAssignmentLogResourceUtilizationServerStateLogUpdatePerformanceLogCoreV2IndexUpdatePerformanceLogCoreV2WorkspaceDataSnapshotWorkspaceData