Have you tried this:
UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
UPDATE dbo.Settings SET CurrentValue = 0 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
Then run DB Maitenance.
To turn off defragmentation:
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.
Tomas,
Would you mind please sharing the options for these configurations and how to get to them?
Thank you
