Databases

The Databases window shows information about the Databases activity. 

The grid located at the top of the window shows each individual database with the following information for each one:

Data Size(MB), Cumulative size (in Mbytes) of all the data files in the database including any automatic growth. Monitoring this counter is useful, for example, for determining the correct size of tempdb.
Log Size(MB) Cumulative size (in Mbytes) of all the transaction log files in the database.
Log Used(MB) The cumulative used size of all the log files in the database.
% Log Used Percentage of space in the log that is in use.
Log Cache Hit Ratio Percentage of log cache reads satisfied from the log cache.
Log Flushes/s, Number of log flushes per second.
Log Flush Wait Time(ms/s) Total wait time (in milliseconds) to flush the log.
Log Flush Waits/sec Number of commits per second waiting for the log flush.
Log Growths Total number of times the transaction log for the database has been expanded.
Log Shrinks Total number of times the transaction log for the database has been shrunk.
Log Truncations Total number of times the transaction log for the database has been truncated.
Active Transactions Number of active transactions for the database.
Transactions/sec Number of transactions started for the database per second.
Backup/Restore Throughput/sec Read/write throughput for backup and restore operations of a database per second. For example, you can measure how the performance of the database backup operation changes when more backup devices are used in parallel or when faster devices are used. Throughput of a database backup or restore operation allows you to determine the progress and performance of your backup and restore operations.
Bulk Copy Throughput/sec Amount of data bulk copied (in kilobytes) per second.

By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Auto-Update" button must be unchecked to be able to navigate through the collected snapshots.

Select one or more databases in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several databases are selected, the statistics are aggregated.

Percent Log Used

Percentage of space in the log that is in use.

Log cache hit ratio

Percentage of log cache reads satisfied from the log cache.

Log Flushes per second

Log Flushes Number of log flushes per second.
Log Flush Waits Number of commits per second waiting for the log flush.

Active Transactions

Number of active transactions for the database.

Transactions per second

Number of transactions started for the database per second.

Throughput per second

Backup/Restore Read/write throughput for backup and restore operations of a database per second. For example, you can measure how the performance of the database backup operation changes when more backup devices are used in parallel or when faster devices are used. Throughput of a database backup or restore operation allows you to determine the progress and performance of your backup and restore operations.
Bulk copy Amount of data bulk copied (in kilobytes) per second.

See also:





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap