- 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
Defragment Efficiently
- 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.
Automate Defragmentation
- 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.
Optimize Defragmentation
- 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.
Management Defragmentation
Customize Defragmentation
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.
Manage Indexes
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.
Report & Notify
Notify Via Email
SQL Defrag Manager provides an early warning system. When the resource check detects that a metric exceeds a user-defined threshold before executing the defragmentation of the database indexes, it sends an email alert. It also sends email alerts when a defragmentation job completes as expected.
View Detailed Metrics
View detailed information such as fragmentation percentage, index and table size, free memory, page density, the rate of increase of fragmentation, defragmentation methods, post-run results, and time to execute.
Report Comprehensively
Access built-in reports that target technical and managerial audiences. Report on the worst fragmented SQL Servers, databases, tables and indexes, reclaimed resources, and other critical information related to fragmentation. Quickly and easily access these reports on demand.
Track Improvement Savings
Reclaim resources from defragmentation of database indexes and track the total improvement on every object in the SQL Server environment daily or ove
Manage at Enterprise Scale
Centrally Manage, Report, and Notify
The central console enables rapid configuration as well as real-time monitoring of activity. It makes it easy to manage and track fragmentation over a large number of SQL Servers.
Discover Indexes Dynamically
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.
Keep Overhead Low
SQL Defrag Manager collects fragmentation details intelligently based on customizable automation policies. It is agent-less and runs quietly in the background as a service, which keeps overhead on SQL Servers low.
Install Quickly and Use Easily
Install SQL Defrag Manager quickly. It supports a mixed environment of Windows integrated security and SQL Server native security.Complete a typical installation and configuration in less than 30 minutes.
System Requirements
Console
- Microsoft Windows: Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, 7, 8, 10
- Microsoft .NET Framework: 4.0
- Microsoft Data Access Components (MDAC): 2.8+
Management Server and Data Repository
- Microsoft Windows: Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, 7, 8, 8.1, 10
- Microsoft .NET Framework: 4.0
- Repository: Microsoft SQL Server: 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 on Windows
Supported Database Platforms
- Microsoft SQL Server: 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 on Windows & Linux
SQL Defrag Manager does not install any components, dynamic link libraries, scripts, stored procedures, or tables on the monitored SQL Servers.
Cloud
SQL Defrag Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).
Version History
Version 3.5
- Improved product installation
- Support for SQL Server 2017
- Support for disabled Transport Layer Security (TLS) v1.0
- Minor improvements and bug fixes
Version 3.4
- Bug fixes
Version 3.3
- Ability to import &/or export policies from Defrag Manager.
- Ability to search for specific objects in Explorer view
- “Rediscover Objects” by databases and tables in addition to server instances
- Support for SQL Server 2016
Version 3.2
- Supports SQL Server 2014
- Adds Command Line Interface (CLI) option to initiate a defragmentation through SQL Defrag Manager from the command line
Version 3.1
- Supports SQL Server 2012
Version 3.0
- Supports individual defragmentation of partitioned indexes
- Allows the user to set index fill factor parameters
- Customizable update statistics options:
- Always (whether or not an optimization is performed)
- Before optimization (Improves performance by enabling better usage of parallelism)
- Never
Version 2.5
- Proactive Resource Verification – Proactively monitor critical system resources to ensure they are within acceptable limits prior to beginning the defragmentation
- Policy Monitoring and Alerting – Continuously monitor system policies and notifications in the event of defragmentation success, failure or delay due to resource usage
- SQL Server 2008 support
Version 2.0
- New options for managing defragmentation
- Support for new SQL Server 2005/2008 defragmentation options
- Online Re-index (for SQL Server Enterprise Edition)
- Sort in tempdb
- Trigger defragmentation based on either fragmentation percentage or scan density
- Prioritize defragmentation processes based on fragmentation level, page density, or index size
- Limit the number of defrag operations to the “top x” worst indexes
- Customize remediation actions based on index size
- Define a “Hard Stop” Time so defrag operations will not run past scheduled intervals
- Customize frequency of defragmentation analysis to keep data up to date without wasting server resources
- Support for new SQL Server 2005/2008 defragmentation options
- Policy-based Automation/Scheduling
- 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
- Policies allow for flexible customization including all of the new defragmentation management options listed above
- Auto-Discovery of SQL Server indexes – 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
- Remote Repository – Support installations that use a remote SQL Server repository (from the service)
- Built-in reports – 10+ new built-in reports based on SQL Server Reporting Services
- GUI enhancements – Improved ease of use
Compare the Top SQL Server Index Defragmentation Tools
IDERA relentlessly delivers the industry’s most complete solution for 24×7 SQL server performance monitoring, alerting, and diagnostics and tirelessly supports the SQL community with 100% free tools and expert advice.
Compare, side by side, the features and functionalities of the best SQL Server index defragmentation tools the market has to offer. Download a free trial today!
| IDERA SQL Defrag Manager | SQL Sentry® Fragmentation Manager | Microsoft® SQL Server® 2014/2012 | |
|---|---|---|---|
| Analyze and Defrag by Server, DB, Table, or Index | |||
| Automated Defrag Scheduling | |||
| Single Defrag Dashboard for all SQL Servers | |||
| System Resource Conflict Checks and Alerts | |||
| Manage Fill Factors | |||
| Historical Charting | |||
| Comprehensive Reporting |
Discover Why IDERA Has the Best SQL Server Index Defragmentation Tool
Fragmentation can be a silent killer of SQL Server performance. Frequent database inserts, deletes, and merges create index growth problems that remain hidden until performance suffers. IDERA SQL Defrag Manager is your best defense against this killer as it works to identify and eliminate fragmentation problems proactively across all your SQL Servers.
Native Microsoft SQL Server functions like “sys.dm_db_index_physical_stats” provide a lot of useful fragmentation data but using them it is a very manual and reactive solution. If you are just managing a few databases and problem indices this can be enough. Anything larger or more active though requires an automated and proactive strategy to fragmentation maintenance that native tools cannot provide.
A proactive strategy is much more than simply creating automatic defrag schedules as other tools do. IDERA lets you manage fragmentation on your schedule and helps lessen the impact of defrag operations on your environment. Before rebuilding an index, SQL Defrag Manager can check system resources and hold an operation until resources come free or place it on a to-do list to look at later. Defrag operations can be limited to top offenders or have hard stop times so they will run within your maintenance window. IDERA provides the level of flexibility and control required to effectively manage SQL Server index fragmentation.
Download a free, full function 14 day trial of IDERA SQL Defrag Manager right now and discover for yourself how it can make your life simpler, save your company time and money, and help make you a rock star DBA in your organization.
SQL Defrag Manager Product Tour
Fragmentation Explorer: Analyze databases to collect updated fragmentation information, review the analysis results, and defragment the highly-fragmented areas to optimize performance and space usage.
To Do Tasks: View the indexes and partitions that require attention based on automated policies. Choose which activities to perform to defragment the objects that have severe or critical levels of fragmentation.
Recent Activity: Display a list of the analysis and defragmentation tasks performed to view the improvements accomplished during each defragmentation task.
Automation Policies: Analyze database index fragmentation across the enterprise to find and defragment hot spots to improve performance. Use policies to automate this process and maintain databases with minimal time and effort.
Fill Factor Settings: Adjust the fill factor and padding for indexes while viewing recent analysis and fragmentation results for a selected index.
Easily Find and Fix SQL Server Index Fragmentation
Download SQL Defrag Manager Today!
Automatically find and fix SQL Server index fragmentation hot spots in seconds with SQL Defrag Manager.
Fully functional for 14 days. No credit card required (but all fields are).
- Overview
-
- 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
Defragment Efficiently
- 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.
Automate Defragmentation
- 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.
Optimize Defragmentation
- 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.
- Details
-
Management Defragmentation
Customize Defragmentation
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.
Manage Indexes
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.
Report & Notify
Notify Via Email
SQL Defrag Manager provides an early warning system. When the resource check detects that a metric exceeds a user-defined threshold before executing the defragmentation of the database indexes, it sends an email alert. It also sends email alerts when a defragmentation job completes as expected.
View Detailed Metrics
View detailed information such as fragmentation percentage, index and table size, free memory, page density, the rate of increase of fragmentation, defragmentation methods, post-run results, and time to execute.
Report Comprehensively
Access built-in reports that target technical and managerial audiences. Report on the worst fragmented SQL Servers, databases, tables and indexes, reclaimed resources, and other critical information related to fragmentation. Quickly and easily access these reports on demand.
Track Improvement Savings
Reclaim resources from defragmentation of database indexes and track the total improvement on every object in the SQL Server environment daily or ove
Manage at Enterprise Scale
Centrally Manage, Report, and Notify
The central console enables rapid configuration as well as real-time monitoring of activity. It makes it easy to manage and track fragmentation over a large number of SQL Servers.
Discover Indexes Dynamically
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.
Keep Overhead Low
SQL Defrag Manager collects fragmentation details intelligently based on customizable automation policies. It is agent-less and runs quietly in the background as a service, which keeps overhead on SQL Servers low.
Install Quickly and Use Easily
Install SQL Defrag Manager quickly. It supports a mixed environment of Windows integrated security and SQL Server native security.Complete a typical installation and configuration in less than 30 minutes.
- Tec Specs
-
System Requirements
Console
- Microsoft Windows: Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, 7, 8, 10
- Microsoft .NET Framework: 4.0
- Microsoft Data Access Components (MDAC): 2.8+
Management Server and Data Repository
- Microsoft Windows: Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, 7, 8, 8.1, 10
- Microsoft .NET Framework: 4.0
- Repository: Microsoft SQL Server: 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 on Windows
Supported Database Platforms
- Microsoft SQL Server: 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 on Windows & Linux
SQL Defrag Manager does not install any components, dynamic link libraries, scripts, stored procedures, or tables on the monitored SQL Servers.
Cloud
SQL Defrag Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).
Version History
Version 3.5
- Improved product installation
- Support for SQL Server 2017
- Support for disabled Transport Layer Security (TLS) v1.0
- Minor improvements and bug fixes
Version 3.4
- Bug fixes
Version 3.3
- Ability to import &/or export policies from Defrag Manager.
- Ability to search for specific objects in Explorer view
- “Rediscover Objects” by databases and tables in addition to server instances
- Support for SQL Server 2016
Version 3.2
- Supports SQL Server 2014
- Adds Command Line Interface (CLI) option to initiate a defragmentation through SQL Defrag Manager from the command line
Version 3.1
- Supports SQL Server 2012
Version 3.0
- Supports individual defragmentation of partitioned indexes
- Allows the user to set index fill factor parameters
- Customizable update statistics options:
- Always (whether or not an optimization is performed)
- Before optimization (Improves performance by enabling better usage of parallelism)
- Never
Version 2.5
- Proactive Resource Verification – Proactively monitor critical system resources to ensure they are within acceptable limits prior to beginning the defragmentation
- Policy Monitoring and Alerting – Continuously monitor system policies and notifications in the event of defragmentation success, failure or delay due to resource usage
- SQL Server 2008 support
Version 2.0
- New options for managing defragmentation
- Support for new SQL Server 2005/2008 defragmentation options
- Online Re-index (for SQL Server Enterprise Edition)
- Sort in tempdb
- Trigger defragmentation based on either fragmentation percentage or scan density
- Prioritize defragmentation processes based on fragmentation level, page density, or index size
- Limit the number of defrag operations to the “top x” worst indexes
- Customize remediation actions based on index size
- Define a “Hard Stop” Time so defrag operations will not run past scheduled intervals
- Customize frequency of defragmentation analysis to keep data up to date without wasting server resources
- Support for new SQL Server 2005/2008 defragmentation options
- Policy-based Automation/Scheduling
- 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
- Policies allow for flexible customization including all of the new defragmentation management options listed above
- Auto-Discovery of SQL Server indexes – 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
- Remote Repository – Support installations that use a remote SQL Server repository (from the service)
- Built-in reports – 10+ new built-in reports based on SQL Server Reporting Services
- GUI enhancements – Improved ease of use
- Resources
- Compare
-
Compare the Top SQL Server Index Defragmentation Tools
IDERA relentlessly delivers the industry’s most complete solution for 24×7 SQL server performance monitoring, alerting, and diagnostics and tirelessly supports the SQL community with 100% free tools and expert advice.
Compare, side by side, the features and functionalities of the best SQL Server index defragmentation tools the market has to offer. Download a free trial today!
IDERA SQL Defrag Manager SQL Sentry® Fragmentation Manager Microsoft® SQL Server® 2014/2012 Analyze and Defrag by Server, DB, Table, or Index Automated Defrag Scheduling Single Defrag Dashboard for all SQL Servers System Resource Conflict Checks and Alerts Manage Fill Factors Historical Charting Comprehensive Reporting Discover Why IDERA Has the Best SQL Server Index Defragmentation Tool
Fragmentation can be a silent killer of SQL Server performance. Frequent database inserts, deletes, and merges create index growth problems that remain hidden until performance suffers. IDERA SQL Defrag Manager is your best defense against this killer as it works to identify and eliminate fragmentation problems proactively across all your SQL Servers.
Native Microsoft SQL Server functions like “sys.dm_db_index_physical_stats” provide a lot of useful fragmentation data but using them it is a very manual and reactive solution. If you are just managing a few databases and problem indices this can be enough. Anything larger or more active though requires an automated and proactive strategy to fragmentation maintenance that native tools cannot provide.
A proactive strategy is much more than simply creating automatic defrag schedules as other tools do. IDERA lets you manage fragmentation on your schedule and helps lessen the impact of defrag operations on your environment. Before rebuilding an index, SQL Defrag Manager can check system resources and hold an operation until resources come free or place it on a to-do list to look at later. Defrag operations can be limited to top offenders or have hard stop times so they will run within your maintenance window. IDERA provides the level of flexibility and control required to effectively manage SQL Server index fragmentation.
Download a free, full function 14 day trial of IDERA SQL Defrag Manager right now and discover for yourself how it can make your life simpler, save your company time and money, and help make you a rock star DBA in your organization.
- Tour
-
SQL Defrag Manager Product Tour
Fragmentation Explorer: Analyze databases to collect updated fragmentation information, review the analysis results, and defragment the highly-fragmented areas to optimize performance and space usage.
To Do Tasks: View the indexes and partitions that require attention based on automated policies. Choose which activities to perform to defragment the objects that have severe or critical levels of fragmentation.
Recent Activity: Display a list of the analysis and defragmentation tasks performed to view the improvements accomplished during each defragmentation task.
Automation Policies: Analyze database index fragmentation across the enterprise to find and defragment hot spots to improve performance. Use policies to automate this process and maintain databases with minimal time and effort.
Fill Factor Settings: Adjust the fill factor and padding for indexes while viewing recent analysis and fragmentation results for a selected index.
- Download
-
Easily Find and Fix SQL Server Index Fragmentation
Download SQL Defrag Manager Today!
Automatically find and fix SQL Server index fragmentation hot spots in seconds with SQL Defrag Manager.
Fully functional for 14 days. No credit card required (but all fields are).
No credit card required. Fully functional for 14 days!
Buy Now
Includes first year of maintenance.
Volume discounts available
Live Product Demo
See SQL Defrag Manager in action with a seasoned pro.