New in Version 3.0 - Released 8/15/2011 - Release Notes

• 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)
  • Never
  • Before optimization (Improves performance by enabling better usage of parallelism)

New in 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 – Continuous monitoring of system policies and notifications in the event of defragmentation success, failure or delay due to resource usage
  
• SQL Server 2008 support
  

New in 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