You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
Analyze index fragmentation
Rebuild and reorganize fragmented indexes
Create and manage custom policies
Set schedules for defragmentation jobs
Set Email notifications
Monitor index fragmentation on multiple servers
Export all activities to CSV or XML
Create index fragmentation reports


Index fragmentation analysis

Search and analyze indexes by server, database, table, or index. Get detailed information on index type, size, fragmentation percentage, and fill factor with advanced grouping and filtering options Learn more

See next feature

Index defragmentation

Reorganize or rebuild fragmented indexes Learn more

See next feature

Custom policies

Use custom policies to automate database index maintenance. Enable, run or disable a policy with a single click. Learn more

See next feature

Fragmentation thresholds

Set thresholds for reorganizing and rebuilding jobs Learn more

See next feature

Job scheduling

Set daily or weekly schedules for rebuild and reorganize jobs, or execute them in real time

See next feature

Email notifications

Set the Email notification for successful or failed jobs

See next feature


Monitor all defragmentation jobs and policies from a central location Learn more

See next feature

Activities export

Export the activities to CSV or XML

See next feature

Index fragmentation reports

Create reports on index fragmentation and index memory usage for a database, table or a single index

See next feature

Policy templates

Use custom or pre-made policy templates to define and deploy new policies in a few clicks

See next feature


Manage alerts for all defragmentation jobs and policies

See next feature

Statistical reports

Generate statistical reports for most fragmented indexes on the selected server, database or table

See next feature

Fill factor management

Set and monitor index fill factor

See next feature

Proactive resource check

Actively run resource checks for CPU, memory and hard disk usage before creating a policy

See next feature

Custom maintenance scripts

Run custom scripts before or after executing defragmentation policies

See next feature

ApexSQL Defrag 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Defrag features with a brief description

How to automate and schedule SQL Server index defragmentation

This article serves as a guide as to how to automate and schedule SQL Server index defragmentation, and covers three different ways of doing it

How to detect a high level of SQL Server database index fragmentation and fix it automatically

This article describes how to automatically reorganize/rebuild SQL Server database indexes

How to automate SQL Server defragmentation using policies

This article explains solutions for creating fully functional SQL Server defragmentation policy

How to configure fill factor for SQL Server indexes

This article describes Fill Factor overview, and explains different aspects of configuring fill factor for SQL Server indexes

ApexSQL Idera®
SQL Server version
      SQL Server 2005 - 2017
      SQL Server 2019 CTP 2
SQL Server editions
      Azure SQL Database
      Amazon RDS for SQL Server
      Index defragmentation
      Index Fill Factor management
      Index fragmentation analysis
      Index fragmentation and size prediction
Policies and automation
      Custom execution order of policies
      Customizable policy fragmentation thresholds
      Defragmentation job scheduling
      Policy email notification
      Policy management
      Pre made policies
      Automatically detect new database objects
      Analysis and report results filtering
      Custom reports
      Diverse graphical reports
      Graphical history reports
      Report exports
      Proactive system resource check
      System resources availability check with alert
      Duplicate index notice
      Missing index alert
      Unused index notice
      Central management UI
      GUI themes
      High DPI and 4K resolution support
      Microsoft standard iconography, colors and other visual effects

ApexSQL Defrag 2018.05

Idera® SQL Defrag Manager

Comparison was conducted on March 8, 2019

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates


Really loving the ApexSQL offerings. You are now our first choice for SQL tools.

Michael Wolfe

Engineering Supervisor


ApexSQL is my formidable work instrument. I'm a high ROI CRM consultant, and I use this kind of product every day for my projects. ApexSQL is a perfect instrument for my work and a great aid to my productivity.

Angelo Paglialonga

High ROI CRM Consultant

I’ve been using ApexSQL tools since around 2006. ApexSQL Trigger, ApexSQL Diff and ApexSQL Data Diff are my favorites… though ApexSQL Log, and its ability to roll back any change, has been a life saver more than once. I’ve had the pleasure of purchasing ApexSQL Universal with 4 different employers and hope to continue using it until I retire.

Joshua Walker

Database Analyst

Schneider Mills Inc.

I greatly appreciate your assistance. I have to say all of my experiences with ApexSQL have been great. Thank you for the wonderful customer service.

Bryan Benton

Director of Information Technology

Wiginton Corporation

© 2022 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy