Versions Compared

Key

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

The SQL Defrag Manager Analyze Fragmentation window allows you to investigate the fragmentation levels of tables and indexes in the registered databases and instances. The SQL Servers and Databases field lists all the registered instances and databases. Select one or more databases for analysis, specify the type of analysis you want SQL Defrag Manager to perform, and then click Finish. 

Access the Analyze Fragmentation window

To display open the Analyze Fragmentation window, click Analyze on the Fragmentation Explorer tab of the SQL Defrag Manager Console.

...

Fast analysis provides base-level analysis information, including statistics about logical order fragmentation. Logical order fragmentation occurs when the physical order of pages does not match the logical order of the pages. A fast analysis runs five to eight times quicker than a thorough analysis because SQL Defrag Manager does not scan the leaf pages of an index. Therefore, SQL Defrag Manager does not gather page density information during a fast analysis. You can perform a fast analysis on a database that is in use , because it consumes less time and resources than a thorough analysis.

...

Automation allows you to define a custom schedule for analyzing and potentially defragmenting databases during periods of low activity. You can also set SQL Defrag Manager to analyze databases on a regular schedule, such as daily or weekly. Since an analysis can use system resources needed for other common database processes, you may want to schedule this analysis during periods of low database activity or demand.

...

2-Steps analysis

The Fragmentation Explorer tab allows you to easily analyze and defragment individual objects from the navigation tree, such as specific tables and indexes. You can view the most recent analysis results before taking any additional actiona specific instance, database, table, or index, as well as the entire SQL Defrag Manager environment. Right-click the object you want to analyze to open the contextual menu, click the Analyze all/entire... option and select the type of analysis you want to perform. Click here to learn more about actions you can perform from the contextual menu.

Canceling an activity

When an activity is running, SQL Defrag Manager displays displays  a Cancel Activity in  option 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

...

Click the option to stop the activity from running.



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