Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

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.

...

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

...

You can access the Table Statistics tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance , and then selecting Properties. Click Table Statistics when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.

...

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.

...