SQL Server: Databases

3 4

This object contains a set of counters that monitor each database in the system. The object instance chosen represents the database that you can monitor. Databases that can be monitored include the master, model, msdb, and tempdb databases, as well as the Northwind database, the pubs database, and all of your user-created databases. The counters are as follows:

• Active Transactions Number of active transactions in the database.
• Backup/Restore Throughput/sec Throughput of active backup and restore operations per second.
• Bulk Copy Rows/sec Number of rows per second currently being copied via a bulk copy operation.
• Bulk Copy Throughput/sec Number of kilobytes per second currently being copied via a bulk copy operation.
• Data File(s) Size (KB) Total size, in kilobytes, of all of the data files in the database.
• DBCC Logical Scan Bytes/sec Logical read scan rate for DBCC commands.
• Log Bytes Flushed/sec Number of log bytes that are flushed per second.
• Log Cache Hit Ratio Percentage of log reads that were satisfied from the log cache.
• Log Cache Reads/sec Number of log cache reads per second.
• Log File(s) Size (KB) Total size of the log file or files, in kilobytes.
• Log File(s) Used Size (KB) Total amount of space currently used in the log file or files.
• Log Flush Wait Time Total wait time for log flushes, in milliseconds.
• Log Flush Waits/sec Number of log flush waits per second.
• Log Flushes/sec Number of log flushes per second.
• Log Growths Number of log growths, or the number of times the log has extended itself.
• Log Shrinks Number of log shrinks, or the number of times the log has shrunk itself.
• Log Truncations Number of times the log for this database has been truncated.
• Percent Log Used Percentage of the log that is being used.
• Repl. Pending Xacts Number of pending replication transactions in this database.
• Repl. Trans. Rate Number of replication transactions per second.
• Shrink Data Movement Bytes/sec Rate that data is being moved by an autoshrink operation or by a DBCC command.
• Transactions/sec Number of transactions per second for this database. This counter shows you how much activity is occurring in your system. The higher the value, the more activity that is occurring.