Contents

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
• Background Information on Metrics, Thresholds, and Alerts

1 Microsoft SQL Server Metrics

• Configuration Metrics
  • SQL Server Configuration Metrics
  • Registry Setting Configuration Metrics
  • Database Setting Configuration Metrics
• Access Methods Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Agent Status Metrics
• Buffer Manager Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Cache Manager Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Database Metrics
• Database Backup Metrics
• Database Job Metrics
• Database Lock Metrics
• Database Parameter Metrics
• Database Performance Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Event Log Entry Metrics
• General Statistics Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Integrated Security Setting Metrics
• Last Database Backup Metrics
• Login Metrics
• MSSQL Database File Metrics
• MSSQL File Group Metrics
• MSSQL Transaction Log Metrics
• Memory Manager Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Memory Statistics Metrics
• Processor Metrics
• Response Metrics
• SQL Server Locks Metrics
  • For Microsoft SQL Server 2000/2005/2008
• SQL Server Process Metrics
• SQL Server Role Metrics
• SQL Statistics Metrics
  • For Microsoft SQL Server 2000/2005/2008
• Server Statistics Metrics
• User Metrics
• Windows Cluster Name Metrics
  • For Microsoft SQL Server 2005
• Windows Cluster Nodes Metrics
  • For Microsoft SQL Server 2005
• Windows Cluster Resources Metrics
  • For Microsoft SQL Server 2005
• Cluster Name and Network Metrics
  • For Microsoft SQL Server 2005
• Cluster Resource and Type Metrics
  • For Microsoft SQL Server 2005
• Cluster Resource and Group Metrics
  • For Microsoft SQL Server 2005
• Cluster Active Group and Node Metrics
  • For Microsoft SQL Server 2005
• Cluster Resource Group and Cluster Name Metrics
  • For Microsoft SQL Server 2005
• Cluster Active Resource and Node Metrics
  • For Microsoft SQL Server 2005
• Cluster Quorom Resource and Cluster Name Metrics
  • For Microsoft SQL Server 2005
• Cluster Resource and Owner Node Name Metrics
  • For Microsoft SQL Server 2005
• Cluster Resource and Cluster Name Metrics
  • For Microsoft SQL Server 2005
• Cluster Resource Group and Preferred Node Metrics
  • For Microsoft SQL Server 2005
• Index/Table Fragmentation Metrics

2 IBM DB2 Database Metrics

• Connections
  • Agent Connection Statistics Metrics
  • Connected Applications Statistics Metrics
• Database Manager Configuration Information
  • Capacity Metrics
  • Connection Metrics
  • Database Instance Metrics
  • Logging and Recovery Metrics
  • Partitioned Database Environment Metrics
• Health Indicators/Alarms
  • Container Health Indicator Metrics
  • Container Health Information Metrics
  • Database Collection Health Indicator Metrics
  • Database Health Indicator Metrics
  • Database Health Information Metrics
  • DBM Health Indicator Metrics
  • DBM Health Information Metrics
  • Tablespaces Health Indicator
  • Tablespaces Health Indicator History
• Monitoring Information
  • Agent Monitoring Metrics
  • Database Monitoring Metrics
  • Database Backup Metrics
  • General Information Metrics
• Performance
  • Agent Performance Metrics
  • Bufferpool Database Performance Metrics
  • Bufferpool Performance Metrics
  • Cache Statistics Metrics
  • Log I/O Performance Metrics
  • Memory Manager Metrics
  • Sort Heap Metrics
  • Non-Buffered I/O Activity Metrics
• Response Metrics
• Storage Information
  • Data Files Storage Metrics
  • Log Storage Metrics
  • Tablespace Storage Metrics
• System Configuration Information
  • Database System Information Metrics
  • Instance Information Metrics
  • Product Information Metrics
  • Partition Information Metrics
  • Registry Settings Metrics
• DB2 Diag Log File Monitoring Metrics

3 Sybase Adaptive Server Enterprise Database Metrics

• Response
• Databases Instances
• General Statistics
• Cached Objects Statistics
• Cached Procedures Statistics
• Cache Pools Statistics
• Data Cache Statistics
• Deadlock Statistics
• Device Statistics
• Adaptive Server Engines Statistics
• Device Data and IO Log Statistics
• Adaptive Server Statistics
• Locks Information
• Network I/O Statistics
• Open Databases Statistics
• Open Objects Statistics
• Procedure Cache Statistics
• Process Statistics
• Processes Activity Statistics
• Process Tracking Details
• Process Network IO Activity
• Process Objects Information
• Running Procedures Statistics
• Currently Executing SQL Text Information
• Currently Executing Queries
• Waiting Process Statistics
• Adaptive Server State
• Recently (Currently Being) Executed SQL Text
• Most Recently Executed Statement Statistics
• Waiting Events Statistics
• Server-Wide Worker Threads Statistics
• Wait Class Event Information
• Wait Events Information
• Database Usages
• Database Indexes
• Database Login Roles
• Database Logins
• Database Objects
• Database Segments
• Database Thresholds
• Database Transactions
• Database Users
• Most Recent Error Messages
• Segment Usages
• Top Ten Big Cached Objects
• Top Ten Frequently Accessed Cached Objects
• Configuration Metrics
  • Sybase ASE Version Metrics
  • System Listeners Metrics
  • System Databases
  • Installed Scripts
  • Charsets Information
  • Configuration Parameters
  • Database Instances

4 Microsoft SQL Server Reports

5 IBM DB2 Database Reports

6 Sybase Adaptive Server Enterprise Database Reports