Page History
...
To remove the applied filters, right click the instance, database, or table you applied the filters to and choose Clear filter.
Rediscover Objects
Use this feature to update the view of objects found on a specific server, a database, or a table. Right click the specific server, database, or table and select the Rediscover Objects option.
...
You can perform several actions to the entire SQL Defrag Manager environment, to a specific instance, a database, or a table from the tree pane. Right click the target for the action an object to open the contextual menu options.
Actions on the entire SQL Defrag Manager environment
- Analyze all registered SQL Servers: Fast, Thorough-Sampled, Thorough-Detailed
- Defragment all registered SQL Servers: Reorganize, Rebuild, and Rebuild (online)
- Add another SQL Server: Opens the Register SQL Servers configuration window
- Filter:
By - Allows you to filter the objects view by name or keywords
Actions on a specific instance
- Analyze entire server: Fast, Thorough-Sampled, Thorough-Detailed
- Defragment entire server: Reorganize, Rebuild, and Rebuild (online)
- Rediscover server objects: Updates the view of objects found on the server
- Edit configuration for this server: Allows you to modify authentication settings
- Remove this server: Allows you to remove the instance from SQL Defrag Manager
- Add another server: Allows you to register an instance
- Filter: Allows you to filter the objects view by name or keywords
Actions on a specific database
- Analyze entire database: Fast, Thorough-Sampled, Thorough-Detailed
- Defragment entire database: Reorganize, Rebuild, and Rebuild (online)
- Rediscover database objects: Updates the view of objects found on the database
- Filter: Allows you to filter the objects view by name or keywords
Actions on a specific table
- Analyze entire table: Fast, Thorough-Sampled, Thorough-Detailed
- Defragment entire table: Reorganize, Rebuild, and Rebuild (online)
- Rediscover table objects: Updates the view of objects found on the table
- Filter: Allows you to filter the objects view by name or keywords
Performing actions from the objects view
- In the navigation tree, click the database that contains the table you want to analyze or defragment.
- In the right pane, click the Analyze or Defragment option in the panel for the table you want to analyze or defragment.
- Select the analysis or defragmentation type you want to perform.
...
When an activity is running, SQL Defrag Manager displays Cancel Activity in the lower left-hand corner of the status bar. To cancel an activity, click Cancel Activity while the activity runs.
Need more help? Search the IDERA Customer Support Portal
...