Page tree

SQL Defrag Manager provides the following new features:

3.6 New features

  • Recurring Automated Policies
    SQL Defrag now allows policies to run more than once a day
  • Setting Up Automated Policies with Different Analysis Types
    SQL Defrag now offers users the ability to run policies using different Analysis Types
  • New "Instant Defrag" tab
    Rebuild or reorganize all the displayed fragmented hotspots at once with a click of a button
  •                                                                                                                                                                                                                                                                                                                                                                                  


 3.5.1 New Features

3.5.1 New features

  • Support for SQL 2019
    SQL Defrag Manager now supports SQL Server 2019 and update .NET for Management Server and Data Repository
  • Cloud for Azure and AW EC2
    Cloud environment for SQL Defrag to test on Azure and AW EC2. For more information visit Cloud for Azure and AW EC2
  • Support for Windows 2019
    SQL Defrag Manager now supports Windows 2019 and updated .NET for console
  • Support for SQL Server 2019 Database
    SQL Defrag Manager now supports SQL Server 2019 Database Platform
  • Support for databases in Azure
    Support for databases hosted in Azure instances  
 3.5 New features

3.5 New features

  • Support for SQL 2017
    SQL Defrag Manager now supports SQL Server 2017.
  • Auto-discovery
    A new option has been added to policies allowing users to configure auto-discovery of server objects when the policy runs
  • Show a table's schema
    Hovering over a table in the Targets section of the Policy wizard displays a table's schema as a tool tip.
  • Recent Activity Configuration
    Configure the maximum number of displayed items on the Recent Activity pane. You can find more information here.
 3.4 New features

3.4 New features

  • This release does not add extra functionality
 3.3 New features

3.3 New features

  • Import policies
    Allows you to import policies from XML files. Click here to learn more.
  • Export policies
    Allows you to export policies to XML files. Click here to learn more.
  • Navigation tree filtering option
    Allows you to filter the items displayed in the SQL Defrag Manager Explorer by specific name or by keywords (using wildcards). Click here to learn more.
  • "Rediscover Objects" action for databases and tables
    Allows you to quickly Rediscover Objects within a specific database or table. Click here to learn more.
 3.2 New features
  • Supports SQL Server 2014
    SQL Defrag Manager supports the use of SQL Server 2014.
  • Includes a new CLI option that initiates a defragmentation from the command line
    SQL defrag manager 3.2 includes a new command line option that initiates a defragmentation. Use the following CLI option:
    sqldefragc [[[–rebuild [online]] | –reorg] –instance <instance name> –database <database name> | –policy <policy name>]
    You have two options when using this code. You can:
    - Define the defragmentation as follows: specify "rebuild" or "reorg" where "online" is optional for "rebuild"; specify the "instance name"; and specify the "database name".
    - Define the defragmentation based on an existing policy by specifying the "policy name".