Versions Compared

Old Version 6

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 7

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the IDERA SQL Admin Toolset Launchpad, and then click Quick Reindex.
  2. Specify the SQL Server whose indexes you want to check.
  3. Click Load Index Statistics.
  4. If you want to filter the index view by database object , select a database or table that contains the indexes you want view. Click the column headers to sort the indexes.
  5. If you want to resolve high fragmentation , select one or more fragmented indexes, and then click either Reorganize Indexes or Rebuild Indexes.
  6. If you want to reduce the strain on your system , enter the maximum degrees of parallelism in the Quick Reindex warning window. Maximum degrees of parallelism refers to the number of processor cores to be used in the reindex. The default value of 0 allows SQL Server to use all the available processors up to 64.
  7. Select Online Rebuild if you would like to perform the operation without taking the selected indexes offline.
Info

The Online Rebuild and Max Degree of Parallelism options are only available on SQL Server Enterprise and Developer versions.

...