18

In Business Central Cloud (currently version 26), performance issues can arise due to index fragmentation in SQL-based tables. While on-premises environments allow manual index maintenance via SQL Server tools, cloud environments lack native mechanisms for index optimization.


I propose introducing a built-in automated procedure within Business Central Cloud that:

  • Periodically analyzes index fragmentation across tenant tables.
  • Automatically rebuilds or reorganizes indexes based on configurable thresholds.
  • Provides logging and telemetry for tracking optimization events.
  • Offers scheduling options via the Job Queue or Admin Center.


This feature would enhance performance, reduce support overhead, and align with cloud-native best practices for database health and maintenance.

Category: Development
STATUS DETAILS
New

Comments

L

automatically rebuilding of indexes will help us a lot. we have severe issues about damaged indexes in ILE table after installing a new version.

Category: Development