1/12
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
Scripting on this page enhances content navigation, but does not change the content in any way.