Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

How to Use This Manual

• Structure of the Metric Reference Manual
  • Metric Information
  • Definitions of Columns in Metric Summary Tables
  • Abbreviations and Acronyms
• Background Information on Metrics, Thresholds, and Alerts
  • Editing
  • Accessing Metrics Using the Cloud Control Console

1 Microsoft SQL Server Metrics

• 1.1 Viewing Metrics
• 1.2 Access Methods
  • 1.2.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.3 Active SQL Cluster Node
• 1.4 Agent Status
• 1.5 Associated Services
• 1.6 Buffer Manager
  • 1.6.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.7 Cache Manager
  • 1.7.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.8 Cluster Active Group and Node
  • 1.8.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.9 Cluster Active Resource and Node Metrics
  • 1.9.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.10 Cluster Name and Network
  • 1.10.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.11 Cluster Quorom Resource and Cluster Name
  • 1.11.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.12 Cluster Resource and Group
  • 1.12.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.13 Cluster Resource and Type
  • 1.13.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.14 Cluster Resource Group and Cluster Name Metrics
  • 1.14.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.15 Cluster Resource and Owner Node Name
  • 1.15.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.16 Cluster Resource and Cluster Name
  • 1.16.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.17 Cluster Resource Group and Preferred Node
  • 1.17.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.18 Configuration Metrics
  • 1.18.1 SQL Server Configuration Metrics
  • 1.18.2 Registry Setting Configuration Metrics
  • 1.18.3 Database Setting Configuration Metrics
  • 1.18.4 HADR Availability Group Databases Metrics
• 1.19 Connection Statistics
• 1.20 Database
• 1.21 Database Backup
• 1.22 Database IOPS Metrics
• 1.23 Database Job
• 1.24 Database Lock
• 1.25 Database Parameter
• 1.26 Database Performance
  • 1.26.1 For Microsoft SQL Server 2005/2008/2012
• 1.27 Database Status
• 1.28 Detailed Response
• 1.29 Event Log Entry
• 1.30 General Statistics
  • 1.30.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.31 HADR Availability Groups
• 1.32 HADR Availability Group Replicas
• 1.33 HADR Cluster Members
• 1.34 Index/Table Fragmentation Metrics
• 1.35 Index Usage
• 1.36 Last Database Backup
• 1.37 Latches
• 1.38 Latch Wait Time
• 1.39 Login
• 1.40 Memory Manager
  • 1.40.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.41 Memory Statistics
• 1.42 Memory Usage
• 1.43 Mirroring Monitoring
• 1.44 Mirroring Statistics
• 1.45 Missing Indexes
• 1.46 MSSQL Database File
• 1.47 MSSQL File Group
• 1.48 MSSQL Transaction Log
• 1.49 Processor
• 1.50 Response
• 1.51 Server Statistics Metrics
• 1.52 Space Usage
• 1.53 SQL Cluster Nodes Information
• 1.54 SQL Cluster Number of Nodes
• 1.55 SQL Instance Statistics
• 1.56 SQL Server Process Statistics
• 1.57 SQL Server Backups
• 1.58 SQL Server Locks
  • 1.58.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.59 SQL Server Process
• 1.60 SQL Server Role
• 1.61 SQL Statistics
  • 1.61.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.62 Top Queries by CPU Time Metrics
• 1.63 Top Queries by Execution Count
• 1.64 Top Queries by Total Blocked Time
• 1.65 Top Sessions by CPU Utilization
• 1.66 Top Sessions by Memory Utilization
• 1.67 User
• 1.68 Windows Cluster Name
  • 1.68.1 For Microsoft SQL Server 2008/2012/2014/2016
• 1.69 Windows Cluster Nodes
  • 1.69.1 For Microsoft SQL Server 2008/2012/2014/2016

2 IBM DB2 Database Metrics

• 2.1 Viewing Metrics
• 2.2 Connections
  • 2.2.1 Agents Connection
  • 2.2.2 Application Connection
• 2.3 Database Manager Configuration Information
  • 2.3.1 Capacity
  • 2.3.2 Connection
  • 2.3.3 Database Instance
  • 2.3.4 Logging and Recovery
  • 2.3.5 Partitioned Database Environment
• 2.4 Health Indicators/Alarms
  • 2.4.1 Container Health Indicator
  • 2.4.2 Container Health
  • 2.4.3 Database Collection Health Indicator
  • 2.4.4 Database Health
  • 2.4.5 Database Health Indicator
  • 2.4.6 Database Manager Health
  • 2.4.7 Database Manager Health Indicator
  • 2.4.8 Tablespaces Health
  • 2.4.9 Tablespace Health Indicator
• 2.5 Monitoring Information
  • 2.5.1 Agent Monitoring
  • 2.5.2 Database Monitoring
  • 2.5.3 Database Backup Monitoring
  • 2.5.4 General Monitoring
• 2.6 Performance
  • 2.6.1 IO Agents Performance
  • 2.6.2 Database Performance
  • 2.6.3 Bufferpool Performance
  • 2.6.4 Cache Performance
  • 2.6.5 Log IO Performance
  • 2.6.6 Memory Manager Performance
  • 2.6.7 SortHeap Performance
  • 2.6.8 Non-Buffered I/O Performance
• 2.7 Response
• 2.8 Detailed Response
• 2.9 Storage Information
  • 2.9.1 Data Files Storage
  • 2.9.2 Log Storage
  • 2.9.3 Tablespace Storage
• 2.10 System Configuration Information
  • 2.10.1 Database System Information
  • 2.10.2 Instance Information
  • 2.10.3 Product Information
  • 2.10.4 Partition Information
  • 2.10.5 Registry Settings
• 2.11 DB2 Diag Log File Monitoring
• 2.12 HADR Status Metrics
• 2.13 Top Statements by CPU Time Metrics
• 2.14 Top Statements by Execution Count Metrics
• 2.15 Lock Waits Metrics
• 2.16 Lock Waits by Table Metrics
• 2.17 Lock Waits by Blocked Application Metrics
• 2.18 Lock Waits by Blocking Application Metrics

3 Sybase Adaptive Server Enterprise Database Metrics

• 3.1 About Sybase Adaptive Server Enterprise Database Metrics
• 3.2 Viewing Metrics
• 3.3 Adaptive Server Engines Statistics
• 3.4 Adaptive Server State
• 3.5 Adaptive Server Statistics
• 3.6 Cache Pools Statistics
• 3.7 Cached Procedures Statistics
• 3.8 Connection Statistics
• 3.9 Currently Executing Queries
• 3.10 Currently Executing SQL Text Information
• 3.11 Data Caches Statistics
• 3.12 Database Indexes
• 3.13 Database Logins
• 3.14 Database Login Roles
• 3.15 Database Objects
• 3.16 Database Segments
• 3.17 Database Thresholds
• 3.18 Database Transactions
• 3.19 Databases Instances
• 3.20 Deadlock Statistics
• 3.21 Device Data and IO Log Statistics
• 3.22 Devices Statistics
• 3.23 General Statistics
• 3.24 Locks Information
• 3.25 Most Recent Error Messages
• 3.26 Most Recently Executed Statement Statistics
• 3.27 Network I/O Statistics
• 3.28 Open Databases Statistics
• 3.29 Open Objects Statistics
• 3.30 Procedure Cache Statistics
• 3.31 Process Network IO Activity
• 3.32 Process Objects Information
• 3.33 Process Statistics
• 3.34 Process Tracking Details
• 3.35 Processes Activity Statistics
• 3.36 Response
• 3.37 Recently Executed SQL Text
• 3.38 Running Procedures Statistics
• 3.39 Segment Usages
• 3.40 Server-Wide Worker Threads Statistics
• 3.41 Top SQL Statements by CPU Time
• 3.42 Top SQL Statements by Wait Time
• 3.43 Top SQL Statements by Memory Usage
• 3.44 Top Ten Big Cached Objects
• 3.45 Top Ten Frequently Accessed Cached Objects
• 3.46 Transaction Logs
• 3.47 Wait Class Event Information
• 3.48 Wait Events Information
• 3.49 Waiting Events Statistics
• 3.50 Waiting Process Statistics
• 3.51 Configuration Metrics
  • 3.51.1 Charsets Information
  • 3.51.2 Configuration Parameters
  • 3.51.3 Database Instances
  • 3.51.4 Installed Scripts
  • 3.51.5 Sybase ASE Version
  • 3.51.6 System Databases
  • 3.51.7 System Listeners

4 Microsoft SQL Server Reports

5 IBM DB2 Database Reports

6 Sybase Adaptive Server Enterprise Database Reports