You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
 

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

© 2021 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy