You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
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

Features

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

See next feature

Index defragmentation

Reorganize or rebuild fragmented indexes

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

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

Monitoring

Monitor all defragmentation jobs and policies from a central location

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

Alerts

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

ApexSQL Idera®
SQL Server version
      SQL server 2005-2017
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Azure SQL Database
      Amazon RDS for SQL Server
Defrag
      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
Reporting
      Analysis and report results filtering
      Custom reports
      Diverse graphical reports
      Graphical history reports
      Report exports
Alerting
      Proactive system resource check
      System resources availability check with alert
      Duplicate index notice
      Missing index alert
      Unused index notice
Interface
      Central management UI
      GUI themes
      High DPI and 4K resolution support
      Microsoft standard iconography, colors and other visual effects
Price
$499 $1,495

ApexSQL Defrag 2018.02

Idera® SQL Defrag Manager 3.5.0.292


Comparison was conducted on June 27, 2018

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

Volume pricing

per instance

1

$499

2-4

$399

5-9

$349

10-19

$299

Save a bundle

ApexSQL Defrag is included in ApexSQL DBA

12 ApexSQL DBA tools

Priority support

1 year free support and upgrades

New products added for free

Combined 70% savings