You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Defrag release notes

Release:

2017.04.0103

Date:

June 29, 2017

Enhancements:

  • Fragmentation grid filters are available in fragmentation tab ribbon
  • Fragmentation filters are available for the tree view
  • Index statistics reports for page density, fragments count and size ratio of index compared to the other indexes in the grid are available
  • Statistics reports are available for tables, databases and servers
  • Statistic reports are available for top 10 most fragmented clustered and non-clustered indexes
  • Customization options for exported reports are added to Reports tab ribbon
  • Report data retrieval is up to 500% faster
  • Agent health check before application start is implemented
  • Option to start ApexSQL Defrag agent is now available
  • SQL query for getting index statistics in fragmentation grid is up to 8000% faster

Fixes:

  • "Communication with agent failed" message is encountered when grid is refreshed while reorganize job is running
  • "Communication with agent failed" message is encountered when the agent is not running and any option in the Policies grid context menu is selected
  • "Communication with agent failed" message is encountered when the agent is not running and policy with a schedule is created
  • "Do you want to remove all servers?" message is encountered when Remove button is clicked in the ribbon, but no servers are added
  • "Failed to open default email client" message is encountered when log files are sent from Resources tab
  • "The username or password is incorrect" message is encountered in agent installation wizard when username contains one or more space characters
  • Agent status button in the task bar does not work
  • Column names in Activities grid are not the same as the grid in exported files
  • Connection options dialogue does not close when escape button is pressed
  • Connection options form can be reduced in size to an unusable state
  • CPU usage value is displayed in Resource check form instead of values for page density
  • Deep analyze operation lasts too long
  • Drop down menus for column grid filters can be reduced to an unusable state
  • Event notifications are appearing on screen when application is minimized
  • Product icon is missing from taskbar thumbnail
  • Search for duplicate indexes continues even when the connection with agent is lost
  • Server related options are available even if no server is added
  • User created policy templates are deleted on attempt to delete any default template policy
  • User created policy templates are edited on attempt to edit any default policy template
  • User created policy templates configured by editing a default template cannot be deleted
  • User created policy templates configured by editing a default template cannot be edited

Changes:

  • Default policy template names are updated
  • Bottom panel with buttons is removed
  • All buttons that were located in the bottom panel are now available as tabs
  • Interchangeable tab is removed

Release:

2017.03.0088

Date:

May 23, 2017

Enhancements:

  • Support for SQL Server 2017 CTP 2
  • Limited, sampled and detailed index scanning modes are available in the fragmentation view
  • Fast and deep index analysis are available in the Fragmentation tab in the Analyze drop-down menu
  • Predefined policies and policy templates are available in the Policy tab in the Create drop-down menu
  • Pending jobs can be cancelled in the Activities tab
  • A separate Alerts section is added in the bottom bar
  • Filter, group and export alerts
  • Filter activities by status, action type and initialization type

Fixes:

  • Indexes tree view explorer icons are not updated on fragmentation changes
  • The application Agent service cannot start when the central repository database is setup on a default SQL Server instance
  • Blank activities history report file can be exported and saved
  • Date-time stamp is missing in the default name for exported activities history and exported reports
  • Missing validation for email address while creating policies when notifications are enabled
  • “ApexSQL Defrag Agent version is not compatible with this version of ApexSQL Defrag” message is encountered when the application is updated
  • No save as dialog is shown when saving the index duplicates delete script
  • Connection options default values differ from the values defined on initial use
  • Indexes tree view explorer and Fragmentation grid view can be resized to unusable state
  • Customer service link in the Evaluation window opens an empty browser page
  • The application slows down periodically after the Send Logs button is pressed
  • Contact us link in the Resources tab opens an empty browser page
  • “System.ArgumentException” error is encountered on startup when the application is closed while index analysis is still in progress
  • Rebuild indexes operation can be started without selected indexes
  • “An index with the same key has already been added” error is encountered on application startup after updating the application Agent service
  • Grid view columns can be deleted by dragging and dropping outside of 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