Database Index Defragmentation

for SQL Server

SQL Defrag Manager

Automatically Find and Fix

SQL 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.

SQL Defrag Manager
  • 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.
open-quote

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)
open-quote
  • Customize How You Approach

    Defragmentation

    Trigger defragmentation of database indexes by fragmentation percentage and scan density. Prioritize defragmentation by fragmentation level, scan density, and index size.

  • Manage Policies for

    Database Index Defragmentation

    Apply policies for defragmentation of database indexes at level of instances, database, and indexes. Apply the same policy to multiple objects at simultaneously.

  • Manage Index Settings to Control

    SQL Server Index Fill Factor

    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 Before You

    Schedule Defragmentation

    Ascertain utilization of critical system resources before starting defragmentation to delay, prevent, or run as scheduled.

  • Notify via Email with a

    Alert Threshold

    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 on

    Database Fragmentation

    View detailed information such as fragmentation percentage, index and table size, free memory, page density, rate of increase of fragmentation, and more.

  • Report Comprehensively on

    Fragmented Data

    Access built-in reports that target technical and managerial audiences. Report on worst fragmented instances, databases, tables and indexes, and more.

  • Track Improvement For

    SQL Index Defragmentation

    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 on

    Index Fragmentation

    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 to

    Check Index Fragmentation

    As databases, tables, and indexes are created or deleted over time, automatically add new objects and drop deleted objects.

  • Keep Overhead Low

    Agentless Fragmentation Monitoring

    Collect fragmentation details intelligently based on customizable automation policies. Run agentless and quietly in the background as service.

  • Install Quickly and use Easily

    SQL Defrag Manager Setup

    Complete typical installation and configuration in minutes. Support mixed environment of Windows integrated security and SQL Server native security.

  • Install on Cloud Virtual Machines to

    Monitor SQL Index Fragmentation

    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 a Single

    Defragmentation 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

    Defragmentation with Cloud Storage

    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.

If you would like to speak with a representative, then please call +1 (713) 523-4433.

Ready to see how SQL Defrag Manager can help you monitor and manage SQL Server security on-premises and in the cloud?

Datasheet

SQL Defrag Manager
Datasheet

Everything you need to know, all in one downloadable PDF

Play

SQL Defrag Manager
Overview

See how an IT consulting firm tuned SQL Server with SQL Doctor

White Paper

Why Use SQL
Defrag Manager?

 Learn about its automated analysis, intelligent remediation, continuous improvement, centralized management, granular retrospective analysis, and more.

White Paper

What Is Fragmentation?

Learn about fragmentation, the different types, how to defragment, how to compact data, and about interleaved indexes.

Webcast

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.

White Paper

SQL Server Fragmentation
Explained

Learn about the detailed mechanics behind fragmentation and how defragment to improve performance

You can view the list of all resources for
SQL Defrag Manager in the Resource Center.