SQL defrag manager


Technical Features

Powerful, automated, defragmentation management

  • Flexible, customisable control of defragmentation – defrag processes can be triggered by fragmentation percentage or scan density, and prioritized based on fragmentation level, scan density, or index size. Additionally, defrag operations can be limited to the “top x” worst indexes, or by a “hard stop” time.
     
  • 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-based management - Defragmentation policies can be applied at the server, database or index level to apply the same defragmentation management policy to multiple objects all at once. Changing the policy changes the defragmentation approach across all objects simultaneously.
     
  • Automatic, Semi-Automatic or Ad-hoc – provides DBAs the option to run in ”hands free ” mode, approve suggested defragmentation actions, or define exactly how to perform defragmentation automatically.
     
  • Automatically Finds “Worst” Fragmentation Areas – allows you to simply and easily view from the server level down detailed metrics on individual indexes, providing simple and automated methods for detecting, prioritizing and fixing your “worst” fragmentation problems.
     
  • Detailed Metrics – includes information such as fragmentation percentage, index and table size, free bytes, page density, rate of fragmentation increase, defragmentation methods and post-run results, and time to execute.
     
  • Lightweight Collection – fragmentation details are intelligently collected based on customizable automation policies, keeping overhead on your monitored servers low.
     
  • Supports Multiple Levels of Operations – takes actions at the server level or at a more fine grained level for tables and all attached indexes, specific indexes, or indexed views. Additionally, remediation actions can be customized by index size.

Enterprise Management Features

  • Central Enterprise Management Console – enables rapid configuration as well as real-time monitoring of activity. This makes it easy to manage and track fragmentation over a large number of servers.
     
  • Dynamic index discovery - As databases, tables and indexes are created or deleted over time, SQL defrag manager automatically adds new objects and drops deleted objects on a daily basis.
     
  • Agent-less Architecture – includes a Management Console, Centralized Collection Service/Engine and Repository, and an Agent-less Management Service.
     
  • Reporting – built-in reports geared to technical or managerial audiences show worst fragmented servers, databases, or tables/indexes, reclaimed resources, and other key fragmentation related information.
     
  • Easy Installation and Use – installs quickly and supports a mixed environment of Windows integrated security and SQL Server native security. A typical installation and configuration will take less than 30 minutes.
     

 

 

Copyright | SQL Tools | Legal | Privacy