For the best web experience, please use IE11+, Chrome, Firefox, or Safari
Free Trials Request Pricing
Home / SQL index monitoring and analysis

SQL index monitoring and analysis

ApexSQL Defrag is a powerful application used for scheduled analyzing and defragmenting of SQL Server database indexes. Its wide range of features allows users to create and manage custom policies, monitor index fragmentation on multiple servers as well as to create index fragmentation reports.
An introduction to ApexSQL Defrag 11:33
Download Free Trial
SQL index monitoring and analysis
Overview Benefits Resources Related Topics
Download Free Trial

Benefits

  • 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 Learn more

Index defragmentation

Reorganize or rebuild fragmented indexes Learn more

Custom policies

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

Fragmentation thresholds

Set thresholds for reorganizing and rebuilding jobs Learn more

Job scheduling

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

Email notifications

Set the Email notification for successful or failed jobs

Monitoring

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

Activities export

Export the activities to CSV or XML

Index fragmentation reports

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

Policy templates

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

Alerts

Manage alerts for all defragmentation jobs and policies

Statistical reports

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

Fill factor management

Set and monitor index fill factor

Proactive resource check

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

Custom maintenance scripts

Run custom scripts before or after executing defragmentation policies

Testimonials

Medisked

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

Michael Wolfe Engineering Supervisor

High ROI CRM Consultant

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

Schneider Mills Inc.

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

Wiginton Corporation

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

Get started now

Monitor and manage SQL index defragmentation in SQL Server.
Download Free Trial