By default, SQL Defrag Manager sets a maximum of 1000 indexes for analysis, reorganization, and rebuilding for each registered instance. Starting with version 3.5 this value can be changed in the SQL Defrag Manager Console or trough the command line.
Changing the value on the SQL Defrag Manager Console
To access the Index Configuration dialog, click Index Configuration on the SQL Defrag Manager command menu of the SQL Defrag Manager Console. To display the command menu, click the SQL Defrag Manager icon in the top left corner of the SQL Defrag Manager Console, as shown in the following image:
Changing the value on the Command line
Open the command line and use the following command.
sqldefragc.exe -set -maxIndexes <value>
<ac:structured-macro ac:macro-id="b174468c-aa81-48fb-81ed-bb1b63a79b84" ac:name="scroll-pdf-ignore" ac:schema-version="1"> <ac:rich-text-body> <p> <a class="external-link" href="http://www.idera.com/support/ServiceFrame.aspx" rel="nofollow">Need more help? Search the IDERA Customer Support Portal</a> </p> <table class="wrapped"> <colgroup> <col/> <col/> <col/> <col/> <col/> <col/> <col/> <col/> </colgroup> <tbody> <tr> <th> <a class="external-link" href="http://www.idera.com/" rel="nofollow">IDERA Website</a> </th> <th> <a class="external-link" href="http://www.idera.com/productssolutions/sqlserver" rel="nofollow">Products</a> </th> <th> <a class="external-link" href="http://www.idera.com/buynow/shoppingcart" rel="nofollow">Purchase</a> </th> <th> <a class="external-link" href="http://www.idera.com/support/productdocuments" rel="nofollow">Support</a> </th> <th colspan="1"> <a class="external-link" href="http://community.idera.com/" rel="nofollow">Community</a> </th> <th colspan="1"> <a class="external-link" href="http://www.idera.com/about/aboutus" rel="nofollow">About Us</a> </th> <th colspan="1"> <a class="external-link" href="http://www.idera.com/resourcecentral" rel="nofollow">Resources</a> </th> <th colspan="1"> <a href="http://wiki.idera.com/display/SQLDefragManager/Legal+notice">Legal</a> </th> </tr> </tbody> </table> </ac:rich-text-body></ac:structured-macro>