App DB indexes are fragmented and require fragmentation

#1

Hi,


I recently did a health check on the system and I got this error

Image title



Does anyone know how to defragment it?



I did a health check for this specific error I got


Image title



Not sure if it's related though.....


Any help would be appreciated.


Thanks.



#2

Hi Daniel,


As you probably guessed, the "DBI0030" health check for "Check Fragmented Indexes in App DB" ensures that the indexes in the Application Database (App DB) are not overly fragmented which may lead to reduced performance. Usually, the easiest way to defragment the App DB indexes, it so click on the "Apply Fix" option which will execute this task for you. Then you can run the health check again and ensure the issue is gone.


Here are screenshots of Dundas BI health check before and after performing this fix:


Before:

Image title

After:

Image title

Did you try to apply the fix and then received the error you mentioned ("transaction deadlocked ") or did you get this error while running another health check?


You may also go through the following support article to get more information on the working of health checks in Dundas BI:

https://www.dundas.com/support/learning/documentation/administration/health-check

#3

Thanks!


I totally didn't see the apply fix button.