|
The database is at the core of today's critical business applications.Zyrion’s 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
|
Supported Metrics
| |
Microsoft SQL server
Auto Param Total
Auto Param Failed
Auto Param Safe
Auto Param Unsafe
Batch Requests
Compilations
Re-Complications
Logging In Users
Logging Out Users
Connected Users
Database Txn: Active
Database Txn: Rate
Log Cache Hit Ratio
Log Space Usage
Lock Wait Time
Lock Req/Deadlocks
Database Status
Percentage Used
Percentage Remain
Database Performance Counter
Database Errors
Database IO
Postgres SQL database
Database Size
Number of Connections
Number of Locks
Heap Blocks (Read/Hit)
Number of SQL Queries
Longest Running SQL Query
Maximum Transaction Time
Maximum Idle Transaction Time
Number of Index Scans
Number of Database Commits
Number of Database Rollbacks
Number of Table Inserts
Number of Table Updates
Number of Table Deletes
|
Oracle
Performance Counter
Table Space Utilization
Table Status
Replication Schema Status
Listener Status
SID Client Connections
Commited transactions
Aborted transactions
Datafile Reads
Datafile writes
Number of Logged In Users
Buffer Cache Hit Ratio
Data Dictionary Cache Ratio
Library Cache Ratio
Memory vs. Disk Sort Ratio
Number of Sorts
Number of Table Scans
Number of Open Cursors
Number of Redo Log Space Requests
Sybase, DB2 & Ingres
Disk Utilization
Transaction Rate
Disk Reads
Disk Writes
Page Reads
Page Writes
Out Of Space Errors
Requests
Status |
MySQL
Aborted clients
Aborted connects
Queries per second
Handler stats
Delayed Writes
Delayed errors
Created Tmp tables
Key read requests
Opened tables
Max used connections
Qcache hits
Qcache free memory
Qcache free
Joins without keys
Slow queries
Threads created
SQL Query response time
SQL Query response value |
|
