Page History
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.
Access the Table Statistics tab
You can access the Table Statistics tab of the Monitor SQL Server SQL Server Properties window by right-clicking the appropriate monitored SQL Server 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:
|