BeyondERP.Newsletter
Menu

Setup step on the SQL index fragmentation details page · System administration

Check the daily index defragmentation

Use the page when performance drops to see whether the nightly index job ran.

Used by
Information technology manager
Business process
Administer system features
Menu item
SysIndexFragmentationDetails
Main table
SysIndexRebuildActivityLog
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that lists SQL index fragmentation details for each defragmentation run, by table name and index name.
What you do hereUse this page to review the defragmentation status and fragmentation figures recorded for the indexes in each defragmentation run.
ExampleFor example, BEAT users report slow vendor lists one morning; the administrator opens the last defragmentation run and sees the job stopped at its 2-hour limit with indexes still fragmented.
SQL index fragmentation details page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Inquiries › Database › SQL index fragmentation details
Used next byBatch jobs Microsoft Learn
Related pagesDatabase information Checked in Dynamics 365
In this process Read and clean up the database log · Set how batch jobs keep history and retry
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Check the daily index defragmentation

Use the page when performance drops to see whether the nightly index job ran.

Steps from Microsoft

  1. Go to System administration > Inquiries > Database > SQL index fragmentation details.
  2. Select a run in the Defragmentation run list on the left.
  3. Read the Table name, Index name and Defragmentation status for that run.
  4. Use the Filter box to narrow the list of indexes.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Defragmentation runOne run of the index defragmentation system job.Microsoft Learn
Table nameThe table of the index.Checked in Dynamics 365
Index nameThe index that was checked.Checked in Dynamics 365
Defragmentation statusWhat the run did with the index.Checked in Dynamics 365

Common errors and fixes

MessageWhat to do
No run is listed for recent daysCheck on Batch jobs that the index defragmentation system job is not withheld or in error. Microsoft Learn

Test checklist

  1. Open the page and select the latest run.
  2. Check the run date is today or yesterday, which shows the daily job ran.
  3. Filter on a table that users report as slow and read its index status.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check the daily index defragmentationCheck the latest run when users report slow pages, before raising a support caseFragmented indexes slow queries; the system job rebuilds them daily, and this log shows whether it did.What is checked first when pages slow down?Assuming a slow page is caused by fragmentation without checking the run.Test: The daily run is logged

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: Read only.
If you change it laterThe index defragmentation system job runs every day at 3:00 AM local time for at most 2 hours and stops early when few indexes need a rebuild; this page shows what each run did. Microsoft Learn
Technical architect

6Technical

Menu itemSysIndexFragmentationDetails Checked in Dynamics 365
FormSysIndexFragmentationDetails Checked in Dynamics 365
TableSysIndexRebuildActivityLogChecked in Dynamics 365
Who can open itPrivilegesSQL index fragmentation details SysIndexFragmentationDetailsViewDutiesMaintain system settings SysServerSettingsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SysIndexFragmentationDetails
Data migrationLoad order: SQL index fragmentation details has no data entity in Data management, so it can't be loaded from a file or a configuration template. It is a log of each environment's own index job.Checked in Dynamics 365
Table definitionSysIndexRebuildActivityLog columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SA-INQ-550, Check the daily index defragmentation. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-INQ-550