Following are some notes on Microsoft SQL Server MDB maintenance:
The %TEMP% variable must be set to an appropriate working directory before launching the DsmMsSqlOpt.bat script.
It is good practice to rebuild indexes with a fragmentation degree over 30% as the first maintenance step because rebuilding indexes runs much faster than defragmentation. To achieve this, you must launch the DsmMsSqlOpt script with the options -usereindex and -maxfrag=30, for example:
DsmMsSqlOpt.bat -maxfrag=30 -usereindex
After the initial step, all tables with a fragmentation over 10% should be defragmented. This can be done by calling the DsmMsSqlOpt script with the option -maxfrag=10, for example:
