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.
|Mar 1, 2022
|Apr 1, 2022
Developers and administrators can get insights into missing indexes in the database. They can then use a per-tenant extension to add the indexes.
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.
Missing Indexes (docs)