This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Database Maintenance Defragmentation - Not Working

I have index defragmentation selected in polling settings, and it is set to run everyday. However, I am not seeing it finish index defragmentation as it does everything else in the log.

Index defragmentation is also not changing in my monitoring of the database in AppInsight for SQL in SAM.

Can someone confirm my findings with their own dbmaintenance log?

Found here: C:\ProgramData\SolarWinds\Logs\Orion\swdebugMaintenance.log

You can see in the image that it starts, but nothing after that. This is the very end of the log.

pastedImage_0.png

Running it manually completes the maintenance, I watched the progress whenever I had a chance and never saw a message about any particular index being rebuilt, etc.