Versions Compared

Old Version 1

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

Key

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

...

You should run the Top Tables by Fragmentation report on a routine basis, depending on how mission-critical or sensitive the data is and how heavily your company uses the host database. Use this report to identify the tables that you want to optimize for improved performance.

How

...

SQL Diagnostic Manager calculates metric values on this report

Most values on the Top Tables by Fragmentation report correlate with the related SQL Server metric.

...

  • How is the Worst Performing and Most Frequent Queries information gathered? - Solution #00000412
  • How does SQL diagnostic manager Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055

...