Analyze table index trace telemetry

APPLIES TO: Business Central 2021 release wave 1, version 18.0 and later

The table index trace gathers data when an index is added to, modified, or removed from a base table by a table extension.

In AL, an index is defined by a key, which can include one or more table fields. A key in a table extension object can include either fields from the base table or fields from the table extension object itself. A key that includes base tables fields is added as an index on the base table in the SQL database. For more information, see Table Keys.

This signal is emitted when a table extension object is installed or upgraded on a tenant, and it does one of the following operations:

  • Adds an index to the base table
  • Changes an existing index on the base table, for example, it adds or removes fields
  • Removes an existing index from the base table

Index enabled

Occurs when an index was added or modified on the base table by key in a table extension object.

General dimensions

DimensionDescription or value
messageIndex enabled: {alObjectName}
severityLevel1

Custom dimensions

DimensionDescription or value
eventIdLC0024
alObjectIdSpecifies the ID of table that the index was added or changed.
alObjectNameSpecifies the name of table that the index was added or changed.
extensionIdSpecifies the ID of the extension that added the index.
extensionNameSpecifies the name of the extension that added or changed the index.
extensionPublisherSpecifies the publisher of the extension that added or changed the index.
keyMaintainSIFTIndexSpecifies whether the index's MaintainSIFTIndex property is true or false.
keyMaintainSQLIndexSpecifies whether the index's MaintainSQLIndex property is true or false.
keyFieldsSpecifies the table fields that are included in the index.
keyNameSpecifies the name of the index that was added or changed.

Common custom dimensions

The following table explains other custom dimensions that are common to all table index traces.

DimensionDescription or value
aadTenantIdSpecifies the Microsoft Entra tenant ID used for Microsoft Entra authentication. For on-premises, if you aren't using Microsoft Entra authentication, this value is common.
componentDynamics 365 Business Central Server.
componentVersionSpecifies the version number of the component that emits telemetry (see the component dimension.)
deprecatedKeysSpecifies a comma-separated list of all the keys that have been deprecated. The keys in this list are still supported but will eventually be removed in the next major release. We recommend that update any queries that use these keys to use the new key name.
environmentNameSpecifies the name of the tenant environment. See Managing Environments. This dimension isn't included for Business Central on-premises environments.
environmentTypeSpecifies the environment type for the tenant, such as Production, Sandbox, Trial. See Environment Types
telemetrySchemaVersionSpecifies the version of the Business Central telemetry schema.

Index disabled

Occurs when an index was removed from the base table by table extension object.

General dimensions

DimensionDescription or value
messageIndex disabled: {alObjectName}
severityLevel1

Custom dimensions

DimensionDescription or value
eventIdLC0025
alObjectIdSpecifies the ID of table that the index was removed from.
alObjectNameSpecifies the name of table that the index was removed from.
extensionIdSpecifies the ID of the extension that removed the index.
extensionNameSpecifies the name of the extension that removed the index.
extensionPublisherSpecifies the publisher of the extension that removed the index.
keyMaintainSIFTIndexSpecifies whether the index's MaintainSIFTIndex property was true or false.
keyMaintainSQLIndexSpecifies whether the index's MaintainSQLIndex property was true or false.
keyFieldsSpecifies the table fields that are included in the index.
keyNameSpecifies the name of the index that was removed.
See common custom dimensions

Index enabled at runtime

APPLIES TO: Business Central 2026 release wave 1, version 28.0, and later

Occurs when an index is enabled at runtime using the Index Management API.

General dimensions

DimensionDescription or value
messageIndex enabled at runtime: {keyName}
severityLevel1

Custom dimensions

DimensionDescription or value
eventIdLC0063
alObjectIdSpecifies the ID of table that the index was enabled on.
alObjectNameSpecifies the name of table that the index was enabled on.
isALDefinedSpecifies whether the key is defined by AL. Value is true or false.
keyFieldsSpecifies the table fields that are included in the index.
keyMaintainSIFTIndexSpecifies whether the index's MaintainSIFTIndex property is true or false.
keyMaintainSQLIndexSpecifies whether the index's MaintainSQLIndex property is true or false.
keyNameSpecifies the name of the index that was enabled.
keySqlIndexFieldsSpecifies the SQL index fields of the key.
keySumIndexFieldsSpecifies the sum index fields (SIFT) of the key.
See common custom dimensions

Sample KQL code

traces
| where timestamp > ago(60d)
| where customDimensions.eventId == 'LC0063'
| project timestamp
, message
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, alObjectId = customDimensions.alObjectId
, alObjectName = customDimensions.alObjectName
, keyName = customDimensions.keyName
, keyFields = customDimensions.keyFields
, keyMaintainSQLIndex = customDimensions.keyMaintainSQLIndex
, keyMaintainSIFTIndex = customDimensions.keyMaintainSIFTIndex

Index disabled at runtime

APPLIES TO: Business Central 2026 release wave 1, version 28.0, and later

Occurs when an index is disabled at runtime using the Index Management API.

General dimensions

DimensionDescription or value
messageIndex disabled at runtime: {keyName}
severityLevel1

Custom dimensions

DimensionDescription or value
eventIdLC0064
alObjectIdSpecifies the ID of table that the index was disabled on.
alObjectNameSpecifies the name of table that the index was disabled on.
isALDefinedSpecifies whether the key is defined by AL. Value is true or false.
keyFieldsSpecifies the table fields that are included in the index. Only present if the key is AL-defined.
keyMaintainSIFTIndexSpecifies whether the index's MaintainSIFTIndex property is true or false. Only present if the key is AL-defined.
keyMaintainSQLIndexSpecifies whether the index's MaintainSQLIndex property is true or false. Only present if the key is AL-defined.
keyNameSpecifies the name of the index that was disabled.
keySqlIndexFieldsSpecifies the SQL index fields of the key. Only present if the key is AL-defined.
keySumIndexFieldsSpecifies the sum index fields (SIFT) of the key. Only present if the key is AL-defined.
See common custom dimensions

Sample KQL code

traces
| where timestamp > ago(60d)
| where customDimensions.eventId == 'LC0064'
| project timestamp
, message
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, alObjectId = customDimensions.alObjectId
, alObjectName = customDimensions.alObjectName
, keyName = customDimensions.keyName
, isALDefined = customDimensions.isALDefined

Sync table column count exceeded

APPLIES TO: Business Central 2026 release wave 1, version 28.0, and later

Occurs during extension synchronization when a table has more than the recommended limit of 256 SQL columns.

General dimensions

DimensionDescription or value
messageColumn count exceeded recommended limit for {alObjectType} '{alObjectName}'
severityLevel2 (Warning)

Custom dimensions

DimensionDescription or value
eventIdLC0065
alObjectIdSpecifies the ID of the table or table extension that exceeded the recommended column limit.
alObjectNameSpecifies the name of the table or table extension that exceeded the recommended column limit.
alObjectTypeSpecifies whether the AL object is a Table or TableExtension.
columnLimitSpecifies the recommended maximum number of SQL columns. The value is 256.
extensionIdSpecifies the ID of the extension being synchronized.
extensionNameSpecifies the name of the extension being synchronized.
extensionPublisherSpecifies the publisher of the extension being synchronized.
extensionVersionSpecifies the version of the extension being synchronized.
totalColumnCountSpecifies the total number of columns in the SQL table.
See common custom dimensions

Sample KQL code

traces
| where timestamp > ago(60d)
| where customDimensions.eventId == 'LC0065'
| project timestamp
, message
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, alObjectId = customDimensions.alObjectId
, alObjectName = customDimensions.alObjectName
, alObjectType = customDimensions.alObjectType
, extensionName = customDimensions.extensionName
, extensionVersion = customDimensions.extensionVersion
, totalColumnCount = toint(customDimensions.totalColumnCount)
, columnLimit = toint(customDimensions.columnLimit)

Monitoring and Analyzing Telemetry
Enable Sending Telemetry to Application Insights