Network Management

Rebuild and reorganize a database index manually

After running a defrag of the indexes, some users still get a message in the Web Console stating they should defrag the index manually. This article shows you how you can rebuild and reorganize your database manually.

First published date

10/25/2018 12:38 PM

Last published date

11/10/2023 3:03 PM

Overview

This guide can be used to fix tables with errors that will not defragment, such as the error shown below:
"ALTER INDEX REBUILD statement failed because the ONLINE option is not allowed when rebuilding a columnstore index. Rebuild the columnstore index without specifying the ONLINE option"

Product section

Orion Platform

Resolution

To Address the issue these would be the following steps we should do;

Connect to the database using Microsoft SQL Management Studio.
Expand the SolarWinds database and find the table or tables indicated in the message.
Expand the table or tables and go over the indexes.
Right-click the index and choose rebuild and then reorganize.
After rebuilding and reorganizing, right-click the index and click Properties > Fragmentation. The total fragmentation value will be displayed.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.