Versions Compared

Old Version 7

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

Saved on

Key

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

SQL Diagnostic Manager lets you collect statistics and perform trend analysis over time. Table Statistics allow allows you to designate the days and times SQL Diagnostic Manager collects table growth and reorganization statistics. Because statistics collection can negatively impact performance, SQL Diagnostic Manager allows you to designate an individual Table Statistics collection time for the SQL Server SQL Server instances. Configure a time you know the instance is utilized less than normal.

...

  • Limit reorganization to databases over a set size, which eliminates the reorganization of small, rarely-used tables.
  • Exclude  Exclude non-essential databases from the collection by clicking Select Databases to Exclude and selecting the appropriate databases.

Image RemovedImage Added

Access the Table Statistics tab

...

Tip

The SQL Diagnostic Manager Collection Service may not include fragmentation data for a particular table for any of the following reasons:

  • Table statistics collection has not occurred.
  • The database hosting the table is excluded from the collection.
  • The table size does not meet the minimum size threshold.
  • The database hosting the table is not accessible.
  • The table is locked.

...