Performance-related insights into missing indexes


This content is archived and is not being updated. For the latest documentation, go to What's new and planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically Mar 1, 2022 Apr 1, 2022

Business value

Developers and administrators can get insights into missing indexes in the database. They can then use a per-tenant extension to add the indexes.

Feature details

The database for a Business Central environment makes performance counters and information about SQL queries available through Dynamic Management Views (DMVs). It requires direct database access to be able to obtain this information, and for Business Central online environments, this is not possible due to security restrictions.

With this capability, the Business Central platform will make data about missing indexes available as a virtual table, so that the data can be accessed from AL code. We will also add a page on top of the new table to make it easy to get the data without having to write code.

See also

Missing Indexes (docs)