MS SQL Server Perfmon Databases (MSSQL_SERVER_PERFMON_DATABASES)
The MSSQL_SERVER_PERFMON_DATABASES application class in SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. Monitor transactions and the transaction log to determine how much user activity is occurring in the database and how full the transaction log is becoming.
The amount of user activity can determine the performance of the database and affect log size, locking, and replication. Monitoring low-level log activity to gauge user activity and resource usage can help you to identify performance bottlenecks.
Multiple instances of the Databases object, each representing a single database, can be monitored at the same time.
Application class attributes
Item | Description |
|---|---|
Active | Yes |
Created by | Discovery |
Parent class | MSSQL_SERVER_PERFMON_CONTAINER |
Child class | None |
Attributes (parameters)
- Active Transactions (ActiveTransactions)
- Avg Dist From EOL/LP Request (AvgDistFromEOL_LPRequest)
- Backup/Restore Throughput/sec (BackupRestoreThroughputSec)
- Bulk Copy Rows/sec (BulkCopyRowsSec)
- Bulk Copy Throughput/sec (BulkCopyThroughputSec)
- Commit table entries (CommitTableEntries)
- Data File(s) Size (KB) (DataFilesSizeKB)
- Data File(s) Size (MB) (DataFilesSizeMB)
- DBCC Logical Scan Bytes/sec (DBCCLogicalScanBytesSec)
- Log Bytes Flushed/sec (LogBytesFlushedSec)
- Log Cache Hit Ratio (LogCacheHitRatio)
- Log Cache Reads/sec (LogCacheReadsSec)
- Log File(s) Size (KB) (LogFilesSizeKB)
- Log File(s) Size (MB) (LogFilesSizeMB)
- Log File(s) Used Size (KB) (LogFilesUsedSizeKB)
- Log File(s) Used Size (MB) (LogFilesUsedSizeMB)
- Log Flushes/sec (LogFlushesSec)
- Log Flush Waits/sec (LogFlushWaitsSec)
- Log Flush Wait Time (LogFlushWaitTime)
- Log Flush Write Time (ms) (LogFlushWriteTimems)
- Log Growths (LogGrowths)
- Log Pool Cache Misses/sec (LogPoolCacheMissesSec)
- Log Pool Disk Reads/sec (LogPoolDiskReadsSec)
- Log Pool Hash Deletes/sec (LogPoolHashDeletesSec)
- Log Pool Hash Inserts/sec (LogPoolHashInsertsSec)
- Log Pool Invalid Hash Entry/sec (LogPoolInvalidHashEntrySec)
- Log Pool Log Scan Pushes/sec (LogPoolLogScanPushesSec)
- Log Pool LogWriter Pushes/sec (LogPoolLogWriterPushesSec)
- Log Pool Push Empty FreePool/sec (LogPoolPushEmptyFreePoolSec)
- Log Pool Push Low Memory/sec (LogPoolPushLowMemorySec)
- Log Pool Push No Free Buffer/sec (LogPoolPushNoFreeBufferSec)
- Log Pool Req. Behind Trunc/sec (LogPoolReqBehindTruncSec)
- Log Pool Requests/sec (LogPoolRequestsSec)
- Log Pool Requests Old VLF/sec (LogPoolRequestsOldVLFSec)
- Log Pool Total Active Log Size (LogPoolTotalActiveLogSize)
- Log Pool Total Shared Pool Size (LogPoolTotalSharedPoolSize)
- Log Shrinks (LogShrinks)
- Log Truncations (LogTruncations)
- Percent Log Used (PercentLogUsed)
- Repl. Pending Xacts (ReplPendingXacts)
- Repl. Trans. Rate (ReplTransRate)
- Shrink Data Movement Bytes/sec (ShrinkDataMovementBytesSec)
- Tracked transactions/sec (TrackedTransactionsSec)
- Transactions/sec (TransactionsSec)
- Write Transactions/sec (WriteTransactionsSec)
- XTP Controller DLC Latency/Fetch (XTPControllerDLCLatency)
- XTP Controller DLC Peak Latency (XTPControllerDLCPeakLatency)
- XTP Controller Log Processed/sec (XTPControllerLogProcessedSec)
- XTP Memory Used (KB) (XTPMemoryUsedKB)
Comments
Log in or register to comment.