The Top Databases report identifies your worst performing SQL Server databases based on the size of the database, the growth rate of the database, and the number of reads, writes, and transactions per second performed on the database.
You can further filter your monitored databases by wait time with waits that exceed a defined Wait Threshold in milliseconds. Use this report to compile a list of databases that used most often or have the heaviest loads, these databases are shown in different tables: Top Databases By Data Size, Top Databases By Data Growth, Top Databases By Reads Per Second, Top Databases By Writes Per Second, and Top Databases By Transactions Per Second.
You can use % as a wildcard in the Search Value field.
When to run this report
You should run the Top Databases report on a routine basis, such as once a week. This report helps you:
- Plan for upcoming maintenance
- Identify issues that may impact third-party application performance even though the host SQL Server instance remains healthy
- Compare database performance across your enterprise
How SQL Diagnostic Manager calculates metric values on this report
Most values on the Top Databases report correlate with the related SQL Server metric. However, some metric values represent averages over time. Likewise, a few metric values are based on performance algorithms that use multiple statistics to calculate a more accurate metric.
You can access our Customer Support Portal for more information about the algorithm used to calculate a specific metric.
- How is the Worst Performing and Most Frequent Queries information gathered? - Solution #00000412
- How does SQL Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055
- How does SQL Diagnostic Manager calculate the reorganization percentage for database tables? - Solution #00000301
- What does the 'Memory Usage' metric in the Console and Reports represent? - Solution #00002237