Idera SQL defrag manager

As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL Defrag Manager performs an automated analysis of key metrics related to fragmentation to quickly pinpoint those areas where fragmentation is severely hindering performance, then triggers corrective measures.

Manage the defragmentation process through scheduling of jobs at the most optimal time and based on the size of the index. Automate remediation and run the defragmentation utility immediately or during off-peak hours.

Check the utilization of key system indicators prior to execut­ing the defragmentation. This ensures that the policy is able to run as scheduled and avoid any potential system problems or application bottle­necks.

Key Points

Product Features