Contents

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
  • For Microsoft SQL Server 2005
• Agent Status Metrics
• Buffer Manager Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Cache Manager Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Database Metrics
• Database Backup Metrics
• Database Information Metrics
• Database Job Metrics
• Database Lock Metrics
• Database Parameter Metrics
• Database Performance Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Database Session Metrics
• Error Log Entry Metrics
  • For Microsoft SQL Server Database 2000
  • For Microsoft SQL Server Database 2005
• General Statistics Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Integrated Security Setting Metrics
• Last Database Backup Metrics
• Latches Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Login Metrics
• MSSQL Database File Metrics
• MSSQL File Group Metrics
• MSSQL Transaction Log Metrics
• Memory Manager Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Memory Statistics Metrics
• Processor Metrics
• Response Metrics
• SQL Server Locks Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• SQL Server Process Metrics
• SQL Server Role Metrics
• SQL Statistics Metrics
  • For Microsoft SQL Server 2000
  • For Microsoft SQL Server 2005
• Server Alerts Metrics
• Server Statistics Metrics
• User 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