Find and Fix SQL Fragmentation

SQL Defrag Manager

Version 3.3

  • Ability to import &/or export policies from Defrag Manager.
  • Ability to search for specific objects in Explorer view
  • “Rediscover Objects” by databases and tables in addition to server instances
  • Support for SQL Server 2016

Version 3.2

  • Supports SQL Server 2014
  • Adds Command Line Interface (CLI) option to initiate a defragmentation through SQL Defrag Manager from the command line

Version 3.1

  • Supports SQL Server 2012

Version 3.0

  • Supports individual defragmentation of partitioned indexes
  • Allows the user to set index fill factor parameters
  • Customizable update statistics options:
    • Always (whether or not an optimization is performed)
    • Before optimization (Improves performance by enabling better usage of parallelism)
    • Never

Version 2.5

  • Proactive Resource Verification – Proactively monitor critical system resources to ensure they are within acceptable limits prior to beginning the defragmentation
  • Policy Monitoring and Alerting – Continuously monitor system policies and notifications in the event of defragmentation success, failure or delay due to resource usage
  • SQL Server 2008 support

Version 2.0

  • New options for managing defragmentation
    • Support for new SQL Server 2005/2008 defragmentation options
      • Online Re-index (for SQL Server Enterprise Edition)
      • Sort in tempdb
    • Trigger defragmentation based on either fragmentation percentage or scan density
    • Prioritize defragmentation processes based on fragmentation level, page density, or index size
    • Limit the number of defrag operations to the “top x” worst indexes
    • Customize remediation actions based on index size
    • Define a “Hard Stop” Time so defrag operations will not run past scheduled intervals
    • Customize frequency of defragmentation analysis to keep data up to date without wasting server resources
  • Policy-based Automation/Scheduling
    • Defragmentation policies can be applied at the server, database or index level to apply the same defragmentation management policy to multiple objects all at once. Changing the policy changes the defragmentation approach across all objects simultaneously
    • Policies allow for flexible customization including all of the new defragmentation management options listed above
  • Auto-Discovery of SQL Server indexes - as databases, tables and indexes are created or deleted over time, SQL defrag manager automatically adds new objects and drops deleted objects on a daily basis
  • Remote Repository - Support installations that use a remote SQL Server repository (from the service)
  • Built-in reports - 10+ new built-in reports based on SQL Server Reporting Services
  • GUI enhancements - Improved ease of use
No credit card required! Fully functional for 14 days HeroImage

Buy Now

Includes first year of maintenance.
Volume discounts available.

Add to Cart

Buy online now and save 50% Use code SQLDFRG50 at checkout

Request a Quote

Live product Demo

See SQL Defrag Manager in action with a seasoned pro.

Request a Demo