You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

SQL Defrag Manager provides the following new features and fixed issues.

3.3 New features

  • Import/Export policies
    Allows you to import or export policies from and to XML files.
  • Explorer filtering option
    Items displayed in the SQL Defrag Manager Explorer can now be filtered by specific name or by keywords using wildcards.
  • "Rediscover Objects" action for databases and tables
    Allows you to quickly Rediscover Objects within a specific database or table.
  • Supports SQL Server 2016 (pre-release)
    SQL Defrag Manager supports the use of SQL Server 2016 (pre-release).

 

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".

 

Need more help? Search the IDERA Customer Support Portal

  • No labels