For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL Defrag release notes

Release:

2019.02.0210

Date:

April 29, 2020

Enhancements:

Fixes:

  • "Object reference not set to an instance of an object" error is encountered when saving policy template
  • Central repository database connection file is deleted when upgrading to a new major version

Release:

2019.01.0206

Date:

April 2, 2020

Changes:

  • Agent configuration step has been moved to the initial application launch

Release:

2018.09.0198

Date:

December 4, 2019

Fixes:

  • Central Repository Database file is not deleted when application is uninstalled
  • Vertical scroll bar in “Deletescript.sql” editor is missing
  • "The system cannot find the file specified" error is encountered when Databases dropdown button is clicked while (local) option in Servers is selected
  • "Object reference not set to an instance of an object” error is encountered when trying to access a nonexistent SQL Server instance
  • SQL Server can be added when SQL Server authentication is used while incorrect password is provided

Release:

2018.08.0190

Date:

August 12, 2019

Fixes:

  • SQL Servers are not shown in the Server panel, even though indexes are visible in the main grid
  • Index fragmentation is not shown in the main grid for any selected SQL Server and/or its databases
  • The previous version of the application is not uninstalled when updating to a newer version
  • "Please wait..." message is shown indefinitely on the screen after the Central repository connection is established after the clean installation
  • Deleting alerts in the Alerts tab takes too long when the row count exceeds 10,000
  • Fragmentation window is not shown when switching from Policies/Activities/Alerts tabs to Home tab and selecting a database from the Server list
  • Deleted items remain in the Activities tab until the main grid is manually refreshed
  • Deleting items from expanded activity job in the Activities tab deletes the whole activity

Release:

2018.07.0168

Date:

June 21, 2019

Changes:


Release:

2018.07.0167

Date:

May 27, 2019

Fixes:

  • No data is shown for SQL Server 2005 Express edition in the Indexes grid pane

Release:

2018.06.0163

Date:

April 16, 2019

Enhancements:

Changes:

  • The application now requires Microsoft .NET framework 4.7.2

Release:

2018.05.0160

Date:

October 31, 2018

Enhancements:

Fixes:

  • "Object reference not set to an instance of an object" error is encountered when Statistics button is clicked in Reports tab for a newly added server
  • "ApexSQL Defrag Agent has stopped working" error is encountered on Windows Server operating systems when ApexSQL Defrag Agent service is installed directly from the setup file
  • "Select correct interval" message is shown when random database of a newly added server is selected in server panel in Home tab
  • Server panel status is stuck to "Refreshing" after an offline server is removed from the panel
  • Application error message is not shown when ApexSQL Defrag Agent stops working

Release:

2018.04.0148

Date:

July 12, 2018

Fixes:

  • “ApexSQL Defrag has stopped working” error is encountered on application startup if ApexSQL Defrag Agent isn’t already installed

Release:

2018.03.0146

Date:

June 26, 2018

Enhancements:

  • Index fill factor management
  • Scheduler can generate weekly and monthly schedules for the defragmentation policies
  • Server resources verification can be started on demand when defining policies
  • Operation sequence can be defined for policies
  • Custom maintenance scripts can be included in policies
  • Limit the number of CPU cores used for the policy execution
  • Delay policy execution on locked server objects
  • Export the list of registered server objects
  • Index size prediction is available for index size reports
  • All reports can be exported to CSV and XML formats
  • Index rebuild and index reorganize operations can be paused or resumed on demand

Fixes:

  • "ApexSQL Defrag agent has stopped working" error is encountered when the application is updated manually from version 2017.04 to 2018.01
  • "Downloading data" message is displayed in status bar after the update is performed from version 2017.04 to 2018.01
  • New firewall exception is added each time the application is installed
  • New servers cannot be added to the server pane in Home tab after the trial period expires
  • Changes are not saved for the edited policies when new databases are added as policy targets
  • Resources form cannot be closed with (Esc) key
  • Templates form cannot be closed with (Esc) key
  • ApexSQL Defrag agent service log files are not included in email attachment when Send logs button is clicked

Known limitations:

  • Offline status of a database is not displayed in the server tree view

Release:

2018.02.0130

Date:

February 01, 2018

Fixes:

  • "Server not found" error is encountered when the policies that process indexes on SQL Server 2012 and earlier versions are executed

Known limitations:

  • Offline status of a database is not displayed in the server tree view

Release:

2018.01.0127

Date:

December 21, 2017

Enhancements:

Fixes:

  • "There are no duplicate indexes in current analyze result" error is encountered when there are no servers added in the server pane
  • Blank Duplicate indexes form opens after the message "There are no duplicate indexes in current analyze result" is encountered
  • Horizontal column size increases when Refresh button is clicked in Activities tab and activities grid contains no data
  • "Object reference not set to an instance of an object" error is encountered when expanded activities grid is exported as HTML document
  • Exported Activities history HTML report does not have the same grouping as Activities grid
  • Agent status taskbar icon is not updated when agent service stops working
  • No warning or error message is encountered when defragmentation job is run while agent service is stopped
  • "Cannot refresh databases" error is encountered when agent service is inactive
  • Email notifications cannot be set if port number is not specified
  • Wrong values are displayed in the Ended column in Activities tab for all defragmentation jobs that are not completed
  • Wrong values are displayed in Activity details grid when a task that belongs to expanded policy is selected
  • "Invalid name character in 'Start type'. The '' character, hexadecimal value 0x20, cannot be included in a name" error is encountered in Activites tab for all manually input values
  • "Cannot refresh duplicate indexes" error is encountered when duplicate index scan is run against offline databases
  • ESC keyboard shortcut does not close Duplicate indexes form
  • ESC keyboard shortcut does not close Get updates form
  • Two context menus are opened on double right click on fragmentation grid

Changes:

  • Server pane has been removed from Policies tab, Activities tab, and Alerts
  • The application now requires Microsoft .NET Framework 4.7.1
  • New light, blue and dark themes are now available

Known limitations:

  • Offline status of a database is not displayed in the server tree view

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