Transcript

Why use SQL Defrag Manager?

Automated analysis: Analysis of over 20 key metrics to pinpoint fragmentation hotspots.

Intelligent remediation: Intelligent heuristics to determine the best-fit approach and schedule for defragmentation, ensuring minimum impact to production servers.

Continuous improvement: Analysis of historical fragmentation statistics, enabling SQL Defrag Manager to intelligently refine its approach.

Centralized management: Management console to provide central control of defragmentation activity across hundreds of servers.

Granular retrospective analysis: Ability to drill down to a point-in-time snapshot and see what was causing system issues.

Comprehensive reporting: Easily-run reports to verify that database performance is continually optimized.

Resource monitor: Ability to postpone defragmentation operations when resource contention issues are discovered.

Automated alerting: Email alerts to inform administrators of fragmentation issues and policy results.

Easily adjust policies: Set it and forget it policies to easily adjust how you handle your fragmentation issues.

Immediate feedback: Alerts when there are issues and automated responses to common problems.