Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

By default, SQL Defrag Manager sets a maximum of 1000 indexes for analysis, reorganization, and rebuildingonly displays the last 1000 actions on the Recent Activity pane. Starting with version 3.5 users can change 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 Recent Activity Configuration dialog , click  Index Configuration follow these steps:


...

  1. Click on the SQL Defrag Manager

...

  1. icon to open the Command Menu.
    Image Added

  2. Click on Recent Activity Configuration.
    Image Added

  3. On the Recent Activity Configuration dialog set the number of recent actions you want to see on the Recent Activity pane.
    Image Added


Changing the value on the Command line

...

Code Block
sqldefragc.exe -set -maxIndexes <value>



Legal 
Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

Need more help? Search the IDERA Customer Support Portal

IDERA WebsiteProductsPurchaseSupportCommunity About UsResources