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
...
Tip |
---|
The SQL Diagnostic Manager Collection Service may not include fragmentation data for a particular table for any of the following reasons:
|
...