Page History

...

Anchor
contextualfilter contextualfilter

Use the contextual menu filter option

You can apply filters to either the complete SQL Defrag Manager environment (all registered instances), an instance, a database, or a table. From From the navigation tree, rightright-click the object you want to filter and select Filter to open the dialog window.

Use the text field in the dialog to enter the exact name of the instance, database, or table you are searching. You can also use '%' as a wildcard to filter the results by keywords. Use a comma to separate multiple filtering criteria.

Click Find Click Find to apply the filter. SQL Defrag Manager displays the results in the Fragmentation Explorer.

To remove the applied filters, right-click the instance, database, or table you applied the filters to and choose Clear filter, or click the Clear Filters icon Image Modified above the navigation tree.

Anchor
rediscoverobjects rediscoverobjects

Rediscover Objects

Use this feature to update the view of objects found on a specific server, database, or table. Right-click the specific server, database, or table and select the Rediscover Objects option.

Anchor
navigationtree navigationtree

Performing actions from the Explorer navigation tree

You can perform several actions on either the entire SQL Defrag Manager environment, to a specific instance, database, or table from the navigation tree. Right-click an object to open the contextual menu options. The actions available depend on the object selected.

Actions on the entire SQL Defrag Manager environment

• • Analyze all registered SQL Servers: Allows you to select the type of analysis - Fast, Thorough-Sampled, or Thorough-Detailed
  • Defragment all registered SQL Servers: Allows you to select the type of defragmentation - Reorganize, Rebuild, or Rebuild (online)
  • Add another SQL Server: Opens the Register SQL Servers configuration window
  • Filter: Allows  Allows you to filter the objects view by name or keywords

Actions on a specific instance

• • Analyze entire server: Allows you to select select the type of analysis - Fast Fast, Thorough-Sampled, or Thorough-Detailed
  • Defragment entire server: Allows you to select select the type of defragmentation - Reorganize Reorganize, Rebuild, or 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: Allows you to select select the type of analysis - Fast Fast, Thorough-Sampled, or Thorough-Detailed
  • Defragment entire database: Allows you to select select the type of defragmentation - Reorganize Reorganize, Rebuild, or Rebuild (online)
  • Rediscover database objects: Updates  Updates the view of objects found on the database
  • Filter: Allows  Allows you to filter the objects view by name or keywords

Actions on a specific table

• • Analyze entire table: Allows you to select select the type of analysis - Fast Fast, Thorough-Sampled, or Thorough-Detailed
  • Defragment entire table: Allows you to select select the type of defragmentation - Reorganize Reorganize, Rebuild, or Rebuild (online)
  • Rediscover table objects: Updates  Updates the view of objects found on the table
  • Filter: Allows  Allows you to filter the objects view by name or keywords

Performing actions from the objects view

...

1. In the navigation tree, click the database that contains the table you want to analyze or defragment.
2. In the right pane, click the Analyze or Defragment option in the panel for the table you want to analyze or defragment.
   Image RemovedImage Added
3. Select the analysis or defragmentation type you want to perform.

...

When an activity is running, SQL Defrag Manager displays a Cancel Activity option in the lower left-hand corner of the status bar. Click the option to stop the activity from running.

Need more help? Search the IDERA Customer Support Portal

...

...