Versions Compared

Key

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

...

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.

...

In addition to analyzing and defragmenting objects from the database or instance level, this window allows you to analyze and defragment individual objects, such as specific tables and indexes. When you right-click an object in the navigation tree, the context menu provides several options.

 

Performing actions from the Explorer navigation tree

 

You can perform several actions to the entire SQL Defrag Manager environment, a specific instance, database, or table from the tree pane. Right click the target for the action 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 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:
  • Edit configuration for this server:
  • Remove this server:
  • Add another server:
  • Filter:

Actions on a specific database

  • Analyze entire database: Fast, Thorough-Sampled, Thorough-Detailed
  • Defragment entire database: Reorganize, Rebuild, and Rebuild (online)
  • Rediscover database objects:
  • Filter:

Actions on a specific table

 

  • Analyze entire table: Fast, Thorough-Sampled, Thorough-Detailed
  • Defragment entire table: Reorganize, Rebuild, and Rebuild (online)
  • Rediscover table objects:
  • Filter:

To analyze or defragment a specific table:

...