• State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 38 subscribers
  • Views 392 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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.

  • 0

    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%'

  • 0 in reply to mmelton


    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.

  • 0 in reply to tomas.mrkvicka

    Tomas,

    Would you mind please sharing the options for these configurations and how to get to them?

    Thank you

  • 0 in reply to tomas.mrkvicka

    Hi Tomas,

    when the auto index defrag is enabled does it only run when database maintenance runs?

    Regards

    Ciaran

  • 0 in reply to Jason.Henson

    This will show you all dbm-defrag settings available:

    select * from dbo.Settings where SettingID like 'dbm-defrag%'

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.