2 Replies Latest reply on Jun 25, 2012 11:24 AM by pyro13g

    ndexes with fragmentation over 90% found during DB maintenance.

    pyro13g

      Is there a way to make this an alert so I actually see the message vs accidentally seeing it in the events?

        • Re: ndexes with fragmentation over 90% found during DB maintenance.
          Krisz21

          Yes, there is a way:

           

          "To enable automatic index defragmentation on the SQL Server hosting your SolarWinds

          database:

          1. Using SQL Server Management Studio, log in to your SQL Server using an account with sysadmin

          privileges.

          2. On your SQL Server, open SQL Server Management Studio (click Start > All Programs >

          Microsoft SQL Server > SQL Server Management Studio).

          3. Using an account with the sysadminrole, log in to the SQL Server instance hosting your SolarWinds

          database.

          4. Click + to expand Databases > YourSolarWindsDatabase > Tables.

          5. Click New Query.

          6. Enter the following query in the query field:

          UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'

          7. Click Execute."