Page History

...

Use the contextual menu filter option

Filters can be applied from the navigation tree You can apply filters to either the complete SQL Defrag Manager environment (all registered instances), an instance, a database, or a table. RFrom the navigation tree, right click the item 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 to apply multiple filters.

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

...

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

Actions on a specific instance

• • Analyze entire server: Select the type of analysis - Fast, Thorough-Sampled, Thorough-Detailed
  • Defragment entire server: Select the type of defragmentation - 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 Select the type of analysis - Fast, Thorough-Sampled, Thorough-Detailed
  • Defragment entire database: Reorganize Select the type of defragmentation - 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 Select the type of analysis - Fast, Thorough-Sampled, Thorough-Detailed
  • Defragment entire table: Reorganize Select the type of defragmentation - 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

...

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.

Image Added

Need more help? Search the IDERA Customer Support Portal

...