Customizable Defragmentation Control
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.
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.
Specify how much free space SQL Server should leave on an index page via the fill factor settings to limit page splitting and shifting. This helps you to decrease the frequency of your index rebuilds and improve the performance and availability of your SQL server applications.
Proactive System Resource Checks
Ascertain the utilization of key system resources prior to executing the defragmentation utility. If the metric is at a customer defined threshold, the execution of the defrag operation will either be delayed, prevented or run as scheduled.
Provides an early warning system to the database administrator. If the resource check detects that a user defined threshold has been exceeded prior to executing the utility, an email alert is sent to the DBA. Email alerts are also sent to notify a DBA when a defrag job has completed normally.
View detailed information such as fragmentation percentage, index and table size, free bytes, page density, rate of fragmentation increase, defragmentation methods, post-run results, and time to execute.
Built-in reports geared to technical or managerial audiences highlight the worst fragmented servers, databases, tables/indexes, reclaimed resources, and other key fragmentation related information. Users can quickly and easily access these reports on demand.
Improvement Savings Tracking
Reclaim resources from defrag jobs and track the total improvement on every object in your enterprise daily or over a year. You can even produce an annual report showing how much money has been saved through the use of the solution.
Central Enterprise 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 to keep the overall database environment in top health.
Agent-less & Light-weight
Fragmentation details are intelligently collected based on customizable automation policies. SQL defrag manager is agent-less, simply running as a service, quietly in the background which keeps overhead on your servers low.
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.