I get the below event and don't know how to defrag the Indexes
1. To enable automatic index defragmentation on the SQL Server hosting your SolarWinds database:
Using SQL Server Management Studio, log in to your SQL Server using an account with sysadmin privileges.
On your SQL Server, open SQL Server Management Studio (click Start > All Programs > Microsoft SQL Server > SQL Server Management Studio).
Using an account with the sysadmin role, log in to the SQL Server instance hosting your SolarWinds database.
Click + to expand Databases > YourSolarWindsDatabase > Tables.
Click New Query.
Enter the following query in the query field:
UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
Click Execute.
2. To disable automatic index defragmentation on the SQL Server hosting your SolarWinds database:
UPDATE dbo.Settings SET CurrentValue = 0 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
Other settings related to index defragmentation are listed in the Settings table. Each of these settings has a SettingID starting with dbm-defragmentation.
