Versions Compared

Old Version 1

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

You can perform a manual defragmentation using the command line utility sqldefragc. This utility is included with the SQL Defrag Manager installation. 

Note: You need to run the command line console as an Administrator.

Panel
borderStyledashed

sqldefragc [[[–rebuild [online]] | –reorg] –instance <instance name> –database <database name> | –policy <policy name>]


There are two ways to use sqldefragc

  1. Specify rebuild or reorg where online is optional for rebuild, specify the instance name, and specify the database name.

    Panel
    borderStyledashed
    sqldefragc [[–rebuild [online]] | –reorg] –instance <instance name> –database <database name>

  2. Define the defragmentation based on an existing policy by specifying the policy name.

    Panel
    borderStyledashed
    sqldefragc –policy <policy name>



Scroll pdf ignore
SQL Defrag Manager find and fix SQL fragmentation hot spots fast.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
| 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
| 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse