6 Sybase Adaptive Server Enterprise Database Reports

This chapter provides a list of out-of-box reports available for System Monitoring Plug-In for Sybase (ASE) Database.

Table 6-1 Sybase (ASE) Database Reports

Report Name Report Elements

Sybase ASE Performance Statistics

  • CPU Utilization

  • IO Utilization

  • ASE State Summary

  • ASE State Summary...

Sybase ASE Engines Statistics

  • System CPU (by all Engine's) Utilization

  • User CPU (by all Engine's) Utilization

  • Top 10 Engines by System CPU Utilization

  • Top 10 Engines by User CPU Utilization

Sybase ASE Databases Space Statistics

  • Top 10 Databases by Log Space Utilization

  • Top 10 Databases by Data Space Utilization

  • Databases Backup Related Summary

Sybase ASE Device IO Statistics

  • User Data Devices IO Operations Vs Waiting time

  • User Log Devices IO Operations Vs Waiting Time

  • User Data Devices IO Summary

  • User Log Devices IO Summary Tempdb Data Devices IO Operations Vs Waiting Time

  • Tempdb Log Devices IO Operations Vs Waiting Time

  • Tempdb Data Devices IO Summary

  • Tempdb Log Devices IO Summary

  • Device Reads Rate Vs Writes Rate Vs APF Reads Rate

  • Devices Semaphore Requests Rate Vs Waits Rate Device IO Operations Summary

Sybase ASE Data Cache Statistics

  • Data Cache Hit Rate History

  • Data Cache Hit Rates Summary

  • Data Cache Memory Usage

  • Cached Object Accesses by Processes

  • Top 10 Big Objects in Data Cache

  • Top 10 Popular Objects in Data Cache

Sybase ASE Procedure Cache Statistics

  • Procedure Cache Hit Rate History

  • Procedure Cache Memory Usage History

  • Top 10 Objects in Procedure Cache by Memory Usage

Sybase ASE Network IO Monitoring Report

  • Incoming Traffic History

  • Outgoing Traffic History

  • Incoming Packet Traffic History

  • Outgoing Packet Traffic History

Sybase ASE Database Log Statistics

  • Overall Append Log Requests Rate Vs Waits Rate

  • Tempdb Append Log Requests Rate Vs Waits Rate

  • Overall Append Log Waits Percentage

  • Tempdb Append Log Waits Percentage

  • Databases Log Related Summary

Sybase ASE User Statistics

  • Attempted Logins History

  • Top 5 User SQL Statistics Summary

  • Top 3 Users by CPU Time

  • Top 3 Users by DiskIO

  • Top 3 Users by CPU Time - Summary

  • Top 3 Users by DiskIO Time - Summary

  • Top 3 Users by Incoming Network Traffic

  • Top 3 Users by Outgoing Network Traffic

  • Top 3 Users by Incoming Network Traffic - Summary

  • Top 3 Users by Outgoing Network Traffic - Summary

Sybase ASE Process Statistics

  • Top 10 Processes by CPU Time

  • Top 10 Processes by Waiting Time

  • Top 10 Processes by Incoming Network Traffic

  • Top 10 Processes by Outgoing Network Traffic

  • Top 10 Processes by Memory Usage

  • Top 10 Processes by User Log Cache(ULC) Writes Top 10 Processes by Transactions Rate

  • Top 10 Processes by DiskIO Rate

Sybase ASE SQL Statistics

  • Top SQL Statements by CPU Time

  • Top SQL Statements by Memory Usage

  • Top SQL Statements by Wait Time

Sybase ASE Open Objects Statistics

  • Top 5 Hot Objects by Logical Reads

  • Top 5 Hot Objects by Physical Reads

  • Top 5 Hot Objects by APF Reads

  • Top 5 Hot Objects by Page Reads

  • Top 5 Hot Objects by Physical Writes

Sybase ASE Deadlock Statistics

  • Top 10 Processes by Locks Held

  • Deadlock Detail Table

Sybase ASE Worker Threads Statistics

  • Attempted Parallel Queries History

  • Altered Plans History

  • Worker Threads Summary

Sybase ASE Configuration

  • Sybase ASE Version

  • System Listeners

  • Information about Databases

  • Installed Scripts

  • Charsets Information

  • Backup/Recovery Configuration Parameters

  • Cache Manager Configuration Parameters

  • Component Integration Services Configuration Parameters

  • Configuration Options Configuration Parameters

  • DTM Administration Configuration Parameters

  • Diagnostics Configuration Parameters

  • Disk I/O Configuration Parameters

  • Error Log Configuration Parameters

  • Extended Stored Procedure Configuration Parameters

  • General Information Configuration Parameters

  • Java Services Configuration Parameters

  • Languages Configuration Parameters

  • Lock Manager Configuration Parameters

  • Memory Use Configuration Parameters

  • Meta-Data Caches Configuration Parameters

  • Monitoring Configuration Parameters

  • Network Communication Configuration Parameters

  • O/S Resources Configuration Parameters

  • Physical Memory Configuration Parameters

  • Physical Resources Configuration Parameters

  • Processors Configuration Parameters

  • Rep Agent Thread Administration Configuration Parameters

  • Security Related Configuration Parameters

  • SQL Server Administration Configuration Parameters

  • Unicode Configuration Parameters

  • User Environment Configuration Parameters

Sybase ASE Error Statistics

  • Errors Production Rate (per hour)

  • Recent Error Messages Summary

  • Recent Error Messages with Severity 10 to 16

  • Recent Error Messages with Severity 17 to 18

  • Recent Error Messages with Severity 19 to 26

Sybase ASE Transaction Log Statistics

  • Top 5 Transaction Logs by Current Space Utilization (%)

  • Top 5 Transaction Logs by Recent Space Utilization (%)

  • Top 5 Transaction Logs by Current Total Space (MB)

  • Top 5 Transaction Logs by Recent Total Space (MB)

  • Top 5 Transaction Logs by Current Free Space (MB)

  • Top 5 Transaction Logs by Recent Free Space (MB)

  • Top 5 Transaction Logs by Current Used Space (MB)

  • Top 5 Transaction Logs by Recent Used Space (MB)

  • Transaction Log Summary

Figure 6-1 shows the SQL Statistics report available for Sybase Adaptive Server Enterprise Database:

Figure 6-1 Performance Statistics Reports

Description of Figure 6-1 follows
Description of "Figure 6-1 Performance Statistics Reports"