SQL defrag manager is the only SQL Server defragmentation solution in the industry that automates the time-consuming process of pinpointing fragmentation "hot spots" and takes action to defragment indexes automatically or on demand.
Powerful, automated, defragmentation management
Flexible, customizable 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.
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.
Index management: SQL defrag manager allows you to specify how much free space via the fill factor setting ,SQL Server should leave on an index page 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. Additionally, you can view the history of the index fragmentation with the fill factor changes made over time through the graphical user interface.
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.
Proactive System Resource checking: Ascertains 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 be either be delayed, prevented or run as scheduled.
Email Notification: 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. When the defrag job is completed normally, the DBA is notified.
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.
- Less Features
like us
follow us
link to us
channel us
join the circle