Idera SQL Defrag Manager Enterprise 22.214.171.1242
Trigger defragmentation of database indexes by fragmentation percentage and scan density. Prioritize defragmentation by fragmentation level, scan density, and index size. Limit defragmentation to the worst indexes and by fixed time duration.
Manage with Policies
Apply policies for defragmentation of database indexes at the level of SQL Servers, database, and indexes. Apply the same policy to multiple objects at the same time. Change the approach for defragmentation across all objects simultaneously by changing the shared policy.
Specify how much free space SQL Server should leave on an index page via the settings for the fill factor to limit page splitting and shifting. These settings help to decrease the frequency of the rebuilds of the indexes and improve the performance and availability of the applications.
Check System Resources Proactively
Ascertain the utilization of critical system resources before executing the defragmentation of the database indexes. When a metric is at a user-defined threshold, the defragmentation will be delayed, prevented, or run as scheduled.
Improve the experience of application end-users by enhancing database performance via index defragmentation
Gain visibility into database health regarding index fragmentation by viewing a single dashboard for all monitored databases
Proactively prevent problems with database performance before they impact the organization by automating the management of index fragmentation
Efficiently manage entire SQL Server environments by deploying a single tool across the entire environment
Ensure organizational compliance with IT standards by deploying automated policies for index defragmentation
Increase the efficiency of database administrators by reducing the time to manage index fragmentation
Better utilize the investments in IT infrastructure by maximizing database performance via index defragmentation
Simplify the identification of fragmentation hot spots of that reduce the performance of SQL Server by automatically analyzing key indicators.
Efficiently manage and track the defragmentation of many SQL Servers, databases, tables, and indexes across the environment by using the central management console that provides a single pane of glass to manage settings, monitor activity, and report results.
Quickly find the worst fragmented indexes by viewing the color-coded enterprise dashboard with lists that can be sorted to highlight the SQL Servers, databases, tables, and indexes across the environment that are most impacted by fragmentation.
Minimize the time spent on defragmentation by installing and configuring SQL Defrag Manager quickly for the entire environment, and minimize the learning curve by using the intuitive graphical user interface.
Efficiently manage the improvement of the performance of SQL Server via defragmentation by automating the processes of pinpointing fragmentation and subsequent defragmenting.
Reduce the time that is required to manage the maintenance on indexes by applying automation policies for defragmentation to multiple SQL Servers, databases, tables, and indexes across the environment simultaneously.
Minimize System Impact
Reduce the time required to manage many defragmentation jobs for many SQL Servers across the environment by specifying the conditions for when each job is started and stopped.
Minimize the impact of defragmentation jobs by scheduling the jobs at optimal times (such as off-peak hours and maintenance windows) and based on the size of the indexes.
Avoid database contention during defragmentation jobs by checking critical indicators for the utilization of system resources before starting the jobs.
Improve the performance of SQL Server and reduce the frequency of defragmentation by reducing the splitting and shifting of pages by configuring the settings for the fill factor for index pages.
Manage evolving SQL Server environments for defragmentation by automatically adding and removing databases, tables, and indexes from policies on a daily basis.
Fully understand which defragmentation jobs finished successfully and which jobs were terminated prematurely by receiving email notifications for completions and exceptions.
Report on Improvements
Share with management and peers the attained improvements in the performance of SQL Server due to defragmentation by generating reports that highlight the worst fragmented objects (that is, SQL Servers, databases, tables, and indexes), reclaimed resources, and other essential information.
Report on the achieved cost savings from defragmentation by tracking the improvements via reclaimed resources for each SQL Server, database, table, and index across the environment per day and per year.
defragmentation, indexes, database, index, fragmentation, Server, performance, manage, environment, across, Servers, databases, tables, resources, density, settings, worst, policies, Efficiently, objects, defragmentation, indexes, database, index, fragmentation, Server, performance, across, manage, environment, Servers, databases, tables, Efficiently, resources, density, settings, worst, policies, before