You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Defrag release notes

Release:

2017.03.0088

Date:

May 23, 2017

Enhancements:

  • Limited, sampled and detailed index scanning modes are available in fragmentation view
  • Fast and deep index analysis are available on Fragmentation tab under Analyze button
  • Predefined policies and policy templates are available on Policy tab under Create button
  • Added the ability to cancel pending jobs
  • Separate section is added for Alerts
  • Filter, group and export alerts
  • Activities can be filtered by status, action type and initialization type
  • Support for Microsoft SQL Server 2017 CTP 2

Fixes:

  • Tree view icons are not updated on changes
  • ApexSQL Defrag Agent service cannot run when repository is installed on a default SQL Server instance
  • Blank activities history report file can be generated
  • Date-time stamp is missing in default name for exported activities history
  • Date-time stamp is missing in default name for exported reports
  • No error message is shown when no email address is provided with enabled notifications
  • “ApexSQL Defrag Agent version is not compatible with this version of ApexSQL Defrag” message is encountered when application is updated
  • Save location is not displayed when delete script is saved
  • Connection options values change when Defaults button is pressed after fresh install
  • Resizeability issues with tree view and Fragmentation grid view
  • “Customer service” link in Evaluation window opens empty window in browser
  • Application slows down periodically after “Send Logs” button is pressed
  • "Contact us" link in the Resources tab opens empty window in browser
  • “System.ArgumentException” error is encountered on startup when application is closed while index analysis is in progress
  • Rebuild indexes operation can be started without any index selected
  • “An index with the same key has already been added” error is encountered on application startup
  • Grid view columns can be deleted by drag and drop off the application window
  • “Path does not exist” error is encountered when a report for the specified server is exported

Release:

2017.02.0037

Date:

April 10, 2017

Enhancements:

  • Online rebuild of indexes available in the SQL Server Enterprise edition added to the Fragmentation tab
  • Support for SQL Server vNext CTP1
  • Reports generate up to 1,500% faster
  • Scan for duplicate indexes from the Fragmentation tab
  • Analyze command from the Fragmentation tab now searches for and shows unused, redundant, and indexes with large keys
  • ”Show indexes with minimum pages above” option added in the Options dialog
  • Edit server connection button added in the main ribbon of the Home tab
  • Refresh servers button added in the main ribbon of the Home tab
  • Selecting indexes with (Shift+Click) is now available

Fixes:

  • “Repository error occurred” error is encountered when repair of the central repository database is attempted through the Central repository wizard if the central repository database is corrupted
  • The application agent service is not automatically updated when a new application version is installed
  • The application does not preserve maximized window state between sessions
  • “System.TimeoutException” error is encountered after executing any command before the previously executed command action is complete
  • Check indexes from the Fragmentation grid context menu selects wrong indexes when Check by fragmentation command is used
  • Email address can be added when a new policy is created even when no SMTP account is set up
  • Email configuration dialog is not closed via (Esc) key or when the Cancel button is pressed
  • Incorrectly formatted report is created when exporting grouped reports from the Reports tab
  • The value for every day schedule in the Schedule column of the Policies grid is incorrect
  • There is no notification if central repository database already exists when the Configuration wizard is run
  • Multiple application setup instances can be run
  • “Duplicate key row” error is encountered when the changes in the Options dialog are saved
  • “Do you want to remove all servers?” question is encountered when the Remove servers button is pressed even when no servers are previously added
  • Schedule time in the New policy wizard uses current time as the default schedule start time
  • Policy target selection window in the New policy wizard shows no results
  • Policy target server explorer in the New policy wizard shows a different status than the server explorer in the Add server window
  • Scheduled tasks trigger one hour earlier
  • Schedule column in the Policy grid does not sort policies by AM/PM
  • "@" character is automatically added inline when an email address is added in new policy wizard
  • Custom AutoFilter window appears in the Fragmentation grid on mouse right click
  • “Object reference not set to an instance of an object” error is encountered on Collapse command in the tree view context menu for an already collapsed server node
  • Reports get distorted when resized to full screen
  • Fragmentation percentage graph in Reports tab doesn’t reach the end of graph
  • Date format didn’t follow regional settings when Run once policies are created

Changes:

  • The application agent service installation now suggests the current user as default
  • Automatic check for updates is now enabled by default

Release:

2017.01.0011

Date:

December 01, 2016

Enhancements:

  • Added icon overlays in server explorer to highlight fragmentation issues
  • Added options to select/deselect all indexes and toggle display with low, medium, or high fragmentation
  • Added options to set fragmentation levels and colors
  • Improved policy wizard
  • Improved usability in grids and context menus
  • Improved charts

Fixes:

  • Wrong decimal place for Fragmentation % values in Activities
  • Error is displayed when clicking on OK button in Options after the first install
  • Clicking on the whitespace activates the Run ApexSQL Defrag checkbox in Setup wizard
  • Clicking on the whitespace activates the Create desktop icon checkbox in Setup wizard
  • Export to CSV and XML export all activities, not just the selected ones
  • To large textboxes for schedule time and type
  • To large boxes for Reorganize and Rebuild index thresholds
  • Inconsistent heading for Fragmentation % chart in Reports
  • Right clicking on the column heading in the Activities grid displays two context menus
  • Wrong position of Refresh button for the remote servers
  • Unable to execute file in temporary directory. Setup aborted, when downloading and installing ApexSQL Defrag

Fixes:

  • New application icon

Release:

2016.01.0007

Date:

September 29, 2016

Features:

  • Supports SQL Server 2005 and higher
  • Analyze index fragmentation on local and remote SQL Server instances
  • Rebuild and reorganize fragmented indexes
  • Set fragmentation scan density
  • Set the fragmentation thresholds for reorganize and rebuild jobs
  • Create and manage customizable policies
  • Set CPU load threshold and memory load threshold for defragmentation jobs
  • Set the schedule for defragmentation jobs
  • Set the Email notifications for succeeded/failed jobs
  • Monitor all defragmentation jobs and policies from a central location
  • Group the results by any column from the grid
  • Filter the grid results
  • Export the activities to CSV or XML
  • Create fragmentation reports on index fragmentation and index memory usage
  • Get reports for specified timeframe
  • Export reports to PDF, HTML, or image file