When you initially use SQL Defrag Manager, you should first analyze your databases to collect updated fragmentation information. Then, review that information and defragment the highly-fragmented areas. As you become familiar with SQL Defrag Manager, you may choose to automate this process. This section describes how to manually analyze, view, and correct fragmentation issues on tables and indexes. Use the following topics to guide you through the manual defragmentation process.
- Analyze database fragmentation
- View analysis results
- Optimize performance and space usage
- View recent activity
- Using the Command Line