Key Benefits of SQL defrag manager
Automated Analysis & SQL Server Performance Optimization
SQL defrag manager performs automated analysis of key fragmentation metrics to quickly pinpoint page 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.
Proactive, Intelligent System Resource Awareness
SQL defrag manager now provides the DBA with the ability to check the utilization of key system indicators prior to executing the defragmentation. This gives the DBA an added benefit of making sure that the policy is able to run as scheduled and avoid any potential system problems or application bottlenecks.
Policy and Resource Check Alert Notifications
DBAs are notified if a “resource check” prevents the execution of a policy or if there is a problem or delay in executing the defrag job.
Centralized Management
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.
Comprehensive Reporting
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.
|