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.

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

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, 10 to 24 SQL Server databases

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, 100 to 249 SQL Server databases

With SQL Defrag Manager, the time spent on troubleshooting defragmentation has plummeted.

Dennis Anderson, Database Administrator, Framatome

large enterprise, energy and utilities, USA, 10 to 24 SQL Server databases
  • Customize defragmentation

    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.

  • Manage indexes

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

  • Report comprehensively

    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)

*
*
*
*
*

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?

Request Demo Request Quote
Datasheet

SQL Defrag Manager Datasheet

Everything you need to know, all in one downloadable PDF

Play

SQL Defrag Manager Overview

See the main features and benefits of SQL Defrag Manager

infographic

Why Use SQL Defrag Manager?

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

SQL Workload Analysis

What Is Fragmentation?

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

White Paper

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.

Compare SQL

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.

View All