Database Index Defragmentation
for SQL Server
SQL Defrag Manager
Automatically find and fix
database index fragmentation
Database administrators for SQL Server need to maintain the high availability and performance of their databases. Key areas that dramatically affect the performance of SQL Server are indexes that are fragmented and out of cluster. SQL Defrag Manager is a unique solution for defragmenting indexes for SQL Server. It automates the time-consuming process of finding fragmented indexes based on policies for the targeted databases.
- Automate the identification of index fragmentation hot spots.
- Defragment on-demand and via schedules.
- Receive email notifications for policy and resource check exceptions.
- Use a centralized dashboard and detailed reporting.
SQL Defrag Manager reduced by more than 80% the impact of fragmentation on database performance, the time to resolve and report on fragmentation, and system resources used by defragmentation.
Steve Murdoch, IT Manager, Carmichael International Service
(medium enterprise, transportation services, USA)
I find SQL Defrag Manager a great way to automate the defragging of indexes. Manual scripting is such a waste of time.
Hugh Sagar, Database Administrator, Minter Ellison
(medium enterprise, consumer services, Australia)
With SQL Defrag Manager, the time spent on troubleshooting defragmentation has plummeted.
Dennis Anderson, Database Administrator, Framatome
(large enterprise, energy and utilities, USA)
Trigger defragmentation of database indexes by fragmentation percentage and scan density. Prioritize defragmentation by fragmentation level, scan density, and index size.
Manage with policies
Apply policies for defragmentation of database indexes at level of instances, database, and indexes. Apply the same policy to multiple objects at simultaneously.
Specify how much free space SQL Server should leave on the index page via settings for fill factor to limit page splitting and shifting.
Check system resources proactively
Ascertain utilization of critical system resources before starting defragmentation to delay, prevent, or run as scheduled.
Notify via email
When resource check detects that the metric exceeds user-defined threshold before executing the defragmentation of database indexes, it sends an email alert.
View detailed metrics
View detailed information such as fragmentation percentage, index and table size, free memory, page density, rate of increase of fragmentation, and more.
Access built-in reports that target technical and managerial audiences. Report on worst fragmented instances, databases, tables and indexes, and more.
Track improvement savings
Reclaim resources from defragmentation of database indexes and track total improvement on every object in SQL Server environment daily or over year.
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 instances.
Discover indexes dynamically
As databases, tables, and indexes are created or deleted over time, automatically add new objects and drop deleted objects.
Keep overhead low
Collect fragmentation details intelligently based on customizable automation policies. Run agentless and quietly in the background as service.
Install quickly and use easily
Complete typical installation and configuration in minutes. Support mixed environment of Windows integrated security and SQL Server native security.
Install on cloud virtual machines
Unify your control by running SQL Defrag Manager on cloud virtual machines—such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).
Monitor SQL Server on cloud virtual machines
Monitor your SQL Server instances running on cloud virtual machines—such as Azure VM and Amazon EC2.
Monitor hybrid environments with single tool
Save time by using the same monitoring tool for SQL Server databases on-premises (on your physical and virtual machines); and in private, public, and government cloud (on virtual machines).
Access mapped cloud drives
Get most out of cloud with cloud storage that is mapped as network drives or removable drives on Windows with SQL Defrag Manager. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage.
Let’s get started.
Start your 14-day trial, no credit card required (but all fields are).
Commercial licenses are not supported with this trial download. To update to the latest version, please access IDERA’s customer support portal.
Ready to see how SQL Defrag Manager can help you monitor and manage SQL Server security on-premises and in the cloud?
SQL Defrag Manager
Everything you need to know, all in one downloadable PDF
SQL Defrag Manager
See how an IT consulting firm tuned SQL Server with SQL Doctor
Why Use SQL
Learn about its automated analysis, intelligent remediation, continuous improvement, centralized management, granular retrospective analysis, and more.
What Is Fragmentation?
Learn about fragmentation, the different types, how to defragment, how to compact data, and about interleaved indexes.
SQL Server Indexing
Tips and Tricks
Dave Walden presents the different types of indexes, index statistics, how to use indexes to improve queries, and more.
Why SQL Server Health
Checks are lifesavers
Learn about the detailed mechanics behind fragmentation and how defragment to improve performance