ApexSQL Defrag Changelog

What's new in ApexSQL Defrag 2019.02.0210

Apr 29, 2020
  • 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

New in ApexSQL Defrag 2019.01.0206 (Apr 2, 2020)

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

New in ApexSQL Defrag 2019.01.0203 (Dec 18, 2019)

  • Enhancements:
  • SQL Server 2019 support
  • Fixes:
  • Central repository database connection file is removed when updating to a new major version

New in ApexSQL Defrag 2018.09.0197 (Dec 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

New in ApexSQL Defrag 2018.08.0190 (Aug 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

New in ApexSQL Defrag 2018.07.0168 (Jun 21, 2019)

  • Software Transaction Agreement is added as a new step in the installation wizard and updated in accordance with https://www.quest.com/legal/sta.aspx

New in ApexSQL Defrag 2018.07.0167 (May 27, 2019)

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

New in ApexSQL Defrag 2018.06.0163 (Apr 16, 2019)

  • Enhancements:
  • Active Directory support for:
  • Password authentication
  • Integrated authentication
  • Changes:
  • The application now requires Microsoft NET framework 472

New in ApexSQL Defrag 2018.05.0160 (Oct 31, 2018)

  • Enhancements:
  • SQL Server 2019 CTP 2.0 support
  • New error handling and send logs functionality
  • Improved application installer with a dark theme
  • New application icon
  • 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

New in ApexSQL Defrag 2018.04.0149 Patch (Jul 18, 2018)

  • Fixes:
  • Incorrect index size is shown under the Size (KB) column due to a wrong query for reading data for index size

New in ApexSQL Defrag 2018.04.0148 (Jul 12, 2018)

  • Fixes:
  • “ApexSQL Defrag has stopped working” error is encountered during start of the application if it is installed before ApexSQL Defrag Agent

New in ApexSQL Defrag 2018.04.0147 (Jul 12, 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 (Esckey
  • Templates form cannot be closed with (Esckey
  • ApexSQL Defrag agent service log files are not included in email attachment when Send logs button is clicked

New in ApexSQL Defrag 2018.03.0145 (Jun 26, 2018)

  • Enhancements:
  • Index fill factor management is implemented
  • Scheduler can generate weekly and monthly schedules for the defragmentation policies
  • Verification of server resources 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 servers, databases, tables and indexes
  • 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 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) shortcut
  • Templates form cannot be closed with (Esc) shortcut
  • The application attempts to send application log files larger than 5MB when Send logs button is clicked
  • ApexSQL Defrag agent service log files are not included in email attachment when Send logs button is clicked

New in ApexSQL Defrag 2018.02.0130 (Feb 2, 2018)

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

New in ApexSQL Defrag 2018.01.0129 Patch (Jan 25, 2018)

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

New in ApexSQL Defrag 2018.01.0127 (Dec 21, 2017)

  • Enhancements:
  • SQL Server 2017 support
  • High DPI and 4K resolution support
  • Continuous agent health check
  • Policies can be configured to independently run reorganize and/or rebuild jobs
  • 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

New in ApexSQL Defrag 2017.04.0109 Patch (Sep 5, 2017)

  • Fixes:
  • "Cannot refresh databases" error is encountered when application agent stops running
  • Cannot connect to SQL server if there is no local SQL server where application is installed
  • Wrong values are displayed in the Ended column in Activities for the jobs that are not completed
  • Wrong values are displayed in Activity details grid when tasks that belong to expanded policy are selected
  • Email notifications cannot be set to run without specifying the port number

New in ApexSQL Defrag 2017.04.0103 (Jun 30, 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

New in ApexSQL Defrag 2017.03.0088 (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

New in ApexSQL Defrag 2017.02.0037 (Apr 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

New in ApexSQL Defrag 2017.01.0011 (Feb 17, 2017)

  • 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

New in ApexSQL Defrag 2016.01.0007 (Feb 17, 2017)

  • 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