SQL defrag manager

SQL defrag manager performs automated analysis of key fragmentation metrics to quickly pinpoint fragmentation hot spots, those areas where fragmentation is severely hindering performance.

As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL defrag manager continuously monitors fragmentation levels and takes automated action to resolve fragmentation issues, resulting in improved, more consistent server performance.

SQL defrag manager provides three levels of automation for performing defragmentation:

• Automated: SQL defrag manager automatically takes action according to user-specified parameters and fragmentation levels. Unlike brute force scripts or maintenance plans, SQL defrag manager takes the most appropriate actions at the best times.
• Semi-automated: SQL defrag manager generates to-do list items to highlight fragmentation problem areas. You can then address the issues how and when you want with the click of a button.
• Ad-hoc: You initiate fragmentation analysis manually, and take action to defragment at your own discretion.

The SQL defrag manager management console provides a real-time window into fragmentation levels, and the ability to view and manage defragmentation activity across hundreds of servers and thousands of databases.

SQL defrag manager provides comprehensive reporting of analysis and defragmentation activity, giving DBAs and managers the information they need to ensure that database performance is continuously optimized.