5 Replies Latest reply on May 29, 2015 10:22 AM by hibbyhoo

    Manual defragment message

    Sol

        Did a search of both the KB and the forums but didn't find this exact match. How exactly is this manual defragmentation performed?

      Event message:

      Index PK_CustomPollerStatus on table CustomPollerStatus has fragmentation 90.00% and should be defragmented manually.

        • Re: Manual defragment message
          Michael Melton

          Have you tried this:

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


          Then run DB Maitenance.


          To turn off defragmentation:

           

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

            • Re: Manual defragment message
              Tomas Mrkvicka


              Have you tried this:

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

               


              Then run DB Maitenance.


              To turn off defragmentation:

               

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

               

               

               



               

              Via this you enable our automatic defragmentation system which is part of database maintenance. By default is is disabled because index defragmentation can increase time needed for database maintenance and also increase burden to database. So please if you enable it focus carefully on performance of your system.

              By "manual" defragmentation we meant you own action directly on SQL Server.

              Btw. our defragmentation system is quite configurable so if you will have any question feel free to ask.