Page History
The Defragment and Optimization window allows you to defragment one or more instances and databases. The SQL Servers and Databases field lists all the registered instances and databases. You can select the databases you want to defragment, and then select the type of defragmentation approach you want SQL defrag manager Defrag Manager to use. SQL defrag manager Defrag Manager can simply reorganize indexes for optimal performance, or defragment indexes by completely rebuilding them.
...
To display the Defragment and Optimization window, click Defragment on the Fragmentation Explorer tab of the SQL defrag manager Defrag Manager Console.
Selecting instances and databases to defragment
...
If the instance or database you want to defragment is not listed in the SQL Servers and Databases field, you may not have registered it with SQL defrag managerDefrag Manager. To register an instance with SQL defrag managerDefrag Manager, click Register on the Fragmentation Explorer tab of the SQL defrag manager Defrag Manager Console.
Difference between reorganize and rebuild
...
- Database availability
- Logical fragmentation level
- Parallel processor availability
- Page compaction
- Can you stop and restart the process without losing data?
- Can you untangle interleaved indexes?
- Is additional disk space available in the data file?
- Is the index large?
- Do you need to rebuild statistics?
- Should busy pages be skipped?
Reorganize directs SQL defrag manager Defrag Manager to defragment the tables and indexes online. This defragmentation can be stopped without losing progress. The amount of log space used varies with the amount of work completed. During reorganization, SQL defrag manager Defrag Manager skips pages that are in use. In general, select this defragmentation type when the instance or database must be available during defragmentation or when you defragment a small index.
Rebuild (SORT_IN_TEMP) directs SQL defrag manager Defrag Manager to defragment the tables and indexes offline by completely rebuilding the indexes. This defragmentation type requires sufficient free space on your server and the amount of log space used can be extensive in full recovery mode. On large, fragmented indexes, this defragmentation type is significantly faster than a reorganization. In general, select Rebuild when it is acceptable that the database is unavailable during the time that the indexes are rebuilt.
Rebuild - ONLINE (SQL 2005 Enterprise and later) directs SQL defrag manager Defrag Manager to defragment the tables and indexes online by completely rebuilding the indexes. This defragmentation type requires greater resources such as disk space, memory, and processing. Because of the additional operation time and resource consumption, rebuilding online is only recommended when availability is important.
...
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 Defrag Manager to analyze databases on a regular schedule, such as daily or weekly. Because the database is unavailable while SQL defrag manager Defrag Manager rebuilds one or more indexes in the database, you should run this defragmentation during periods when the database can be offline and unavailable.
...
When an activity is running, SQL defrag manager 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 IDERA Customer Support Portal