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

Compare with Current View Page History

« Previous Version 11 Next »

SQL Defrag Manager provides the following 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
    Items displayed in the SQL Defrag Manager Explorer can now be filtered 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.
  • 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

IDERA WebsiteProductsPurchaseSupportCommunity About UsResources Legal 
  • No labels