4 Sybase Adaptive Server Enterprise Database Metrics

This chapter provides descriptions for Sybase Adaptive Server Enterprise Database Plug-In metric categories, and the tables list and describe associated metrics for each category.

• About Sybase Adaptive Server Enterprise Database Metrics

• Viewing Metrics

• Adaptive Server Engines Statistics

• Adaptive Server State

• Adaptive Server Statistics

• Cache Pools Statistics

• Cached Procedures Statistics

• Connection Statistics

• Currently Executing Queries

• Currently Executing SQL Text Information

• Data Caches Statistics

• Database Indexes

• Database Logins

• Database Login Roles

• Database Objects

• Database Segments

• Database Thresholds

• Database Transactions

• Databases Instances

• Deadlock Statistics

• Device Data and IO Log Statistics

• Devices Statistics

• General Statistics

• Locks Information

• Most Recent Error Messages

• Most Recently Executed Statement Statistics

• Network I/O Statistics

• Open Databases Statistics

• Open Objects Statistics

• Procedure Cache Statistics

• Process Network IO Activity

• Process Objects Information

• Process Statistics

• Process Tracking Details

• Processes Activity Statistics

• Response

• Recently Executed SQL Text

• Running Procedures Statistics

• Segment Usages

• Server-Wide Worker Threads Statistics

• Top SQL Statements by CPU Time

• Top SQL Statements by Wait Time

• Top SQL Statements by Memory Usage

• Top Ten Big Cached Objects

• Top Ten Frequently Accessed Cached Objects

• Transaction Logs

• Wait Class Event Information

• Wait Events Information

• Waiting Events Statistics

• Waiting Process Statistics

• Configuration Metrics