1 Reply Latest reply on Dec 17, 2015 1:28 PM by neomatrix1217

    DB Maintenance

    percyhall


      I get the below event and don't know how to defrag the Indexes

      Indexes with fragmentation over 90% found during DB maintenance.
        • Re: DB Maintenance
          neomatrix1217

          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:

          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 = 0 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'

          Click Execute.

          Other settings related to index defragmentation are listed in the Settings table. Each of these settings has a SettingID starting with dbm-defragmentation.

          1 of 1 people found this helpful