Databases

The database is at the core of today's critical business applications. Traverse takes the guesswork out of degraded database response times by presenting and correlating the underlying servers, disks, and database metrics in a consolidated view. Additionally, it measures the actual query response times to simulate real transactions.

While it is important to monitor the database for high availability and peak performance, it is equally important (if not more important) to monitor the impact of database performance on the supported services, ultimately ensuring that the database is always available and running at peak performance so it does not compromise the business process it supports. The key databases Traverse supports include:

  • Microsoft SQL server, Oracle, Sybase, DB2, MySQL Database, Postgres, Hadoop

Supported Metrics

  • MySQL

  • Commit Request
  • Connected Threads
  • Insert Request
  • Key Buffer Efficient
  • Open Files
  • Open Tables
  • Select Request
  • Slow Queries
  • Table Lock Efficiency
  • Total Request
  • Traffic In
  • Traffic Out
  • Update Request
  • Write Buffer Efficiency
  • Oracle

  • Data File filename Physical Reads
  • Buffer Cache Hit Ratio
  • Data Dictionary Cache Hit Ratio
  • Data File Read Operations
  • Data File Write Operations
  • Library Cache Hit Ratio
  • Number Of Log Space Requests
  • Number Of Logged In Users
  • Number Of Open Cursors
  • Number Of Sort Operations
  • Number Of Table Scan Operations
  • Ratio of Sort Operations
  • Tablespace Status
  • Tablespace Usage
  • Hadoop

  • Add Block Operations
  • Average Block Report Time
  • Average Sync Time
  • Block Checksum Average Time
  • Block Checksum Maximum Time
  • Block Checksum Minimum Time
  • Block Checksum Number Of Operations
  • Block Reads
  • Block Removes
  • Block Replications
  • Block Report Operations
  • Block Reports Average Time
  • Block Reports Maximum Time
  • Block Reports Minimum Time
  • Block Reports Number Of Operations
  • Block Verification Failures
  • Block Verifications
  • Block Writes
  • Blocks Under Replicated
  • Bytes Read
  • Bytes Written
  • Copy Block Average Time
  • Copy Block Maximum Time
  • Copy Block Minimum Time
  • Copy Block Operations Time
  • Corrupted Blocks
  • Create File Operations
  • DFS Disk Util
  • DFS Disk Util
  • Data Node Operations
  • Delete File Operations
  • File System Capacity Used
  • Files Appended
  • Files Created
  • Files Renamed
  • Get Block Locations
  • Get Listing Ops
  • Heart Beats Average Time
  • Heart Beats Maximum Time
  • Heart Beats Minimum Time
  • Heart Beats Number Of Operations
  • Info File Operations
  • Journal Transactions Batched in Sync
  • Max Block Report Time
  • Max Sync Time
  • Min Block Report Time
  • Min Sync Time
  • Named Node Operations
  • Read Block Operation Average Time
  • Read Block Operation Maximum Time
  • Read Block Operation Minimum Time
  • Read Block Operation Number Of Operations
  • Read Metadata Operation Average Time
  • Read Metadata Operation Maximum Time
  • Read Metadata Operation Minimum Time
  • Read Metadata Operation Number Of Operations
  • Reads From Local Client
  • Reads From Remote Client
  • Replace Block Operation Average Time
  • Replace Block Operation Maximum Time
  • Replace Block Operation Minimum Time
  • Replace Block Operation Number Of Operations
  • Replication Blocks Pending
  • Replication Blocks Scheduled
  • Safemode Time
  • Sync Operations
  • Total Files
  • Total Load
  • Transaction Average Time
  • Transaction Max Time
  • Transaction Min Time
  • Transaction Operations
  • Write Block Operations Average Time
  • Write Block Operations Maximum Time
  • Write Block Operations Minimum Time
  • Write Block Operations Number Of Operations
  • Writes From Local Client
  • Writes From Remote Client
  • Postgres

  • Database Size
  • Heap Blocks (Read/Hit)
  • Longest Running SQL Query
  • Maximum Idle Transaction Time
  • Maximum Transaction Time
  • Number of Active SQL Queries
  • Number of Connections
  • Number of DELETE Requests
  • Number of INSERT Requests
  • Number of Index Scans
  • Number of Locks
  • Number of Transaction Commits
  • Number of Transaction Rollbacks
  • Number of UPDATE Requests
  • SQL Server

  • Cache Hit Ratio
  • Lock Average Wait
  • Lock Deadlocks
  • Lock Requests
  • Auto Param (Failed)
  • Auto Param (Safe)
  • Auto Param (Total)
  • Auto Param (Unsafe)
  • Batch Requests
  • Buffer Cache Hit Ratio
  • Compilations
  • DB Log File Size
  • DB Log Flush Waits
  • DB Active Transactions
  • DB File Size
  • DB Log Cache Hit Ratio
  • DB Log Space Util
  • DB Transaction Rate
  • Lazy Writes
  • Longest Running Txn Time
  • Page Life Expectancy
  • Page Reads
  • Page Writes
  • Processes Blocked
  • Re-Compilations
  • Target Server Memory
  • Total Server Memory
  • Users Connected
  • Users Logging In
  • Users Logging Out
  • Sybase DB2 Ingres

  • DB Disk Reads
  • DB Disk Util
  • DB Disk Writes
  • DB OutOfSpace Errors
  • DB Page Reads
  • DB Page Writes
  • DB Query
  • DB Status
  • DB Transaction Rate