Analyze Table Index Trace Telemetry

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

Note

Azure Active Directory is now Microsoft Entra ID. Learn more

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

Dimension	Description or value
message	Index enabled: {alObjectName}
severityLevel	1

Custom dimensions

Dimension	Description or value
eventId	LC0024
alObjectId	Specifies the ID of table that the index was added or changed.
alObjectName	Specifies the name of table that the index was added or changed.
extensionId	Specifies the ID of the extension that added the index.
extensionName	Specifies the name of the extension that added or changed the index.
extensionPublisher	Specifies the publisher of the extension that added or changed the index.
keyMaintainSIFTIndex	Specifies whether the index's MaintainSIFTIndex property is true or false.
keyMaintainSQLIndex	Specifies whether the index's MaintainSQLIndex property is true or false.
keyFields	Specifies the table fields that are included in the index.
keyName	Specifies 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.

Dimension	Description or value
aadTenantId	Specifies 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.
component	Dynamics 365 Business Central Server.
componentVersion	Specifies the version number of the component that emits telemetry (see the component dimension.)
deprecatedKeys	Specifies 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.
environmentName	Specifies the name of the tenant environment. See Managing Environments. This dimension isn't included for Business Central on-premises environments.
environmentType	Specifies the environment type for the tenant, such as Production, Sandbox, Trial. See Environment Types
telemetrySchemaVersion	Specifies 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

Dimension	Description or value
message	Index disabled: {alObjectName}
severityLevel	1

Custom dimensions

Dimension	Description or value
eventId	LC0025
alObjectId	Specifies the ID of table that the index was removed from.
alObjectName	Specifies the name of table that the index was removed from.
extensionId	Specifies the ID of the extension that removed the index.
extensionName	Specifies the name of the extension that removed the index.
extensionPublisher	Specifies the publisher of the extension that removed the index.
keyMaintainSIFTIndex	Specifies whether the index's MaintainSIFTIndex property was true or false.
keyMaintainSQLIndex	Specifies whether the index's MaintainSQLIndex property was true or false.
keyFields	Specifies the table fields that are included in the index.
keyName	Specifies the name of the index that was removed.
See common custom dimensions

See also

Monitoring and Analyzing Telemetry
Enable Sending Telemetry to Application Insights