Go to main content
1/11
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's Changed in this Guide?
How to Use This Manual
Structure of the Metric Reference Manual
Background Information on Metrics, Thresholds, and Alerts
1
Microsoft SQL Server Metrics
1.1
Viewing Metrics
1.2
Access Methods
1.2.1
For Microsoft SQL Server 2005/2008/2012
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 2005/2008/2012
1.7
Cache Manager
1.7.1
For Microsoft SQL Server 2000/2005/2008
1.8
Cluster Active Group and Node
1.8.1
For Microsoft SQL Server 2005
1.9
Cluster Active Resource and Node Metrics
1.9.1
For Microsoft SQL Server 2005
1.10
Cluster Name and Network
1.10.1
For Microsoft SQL Server 2005
1.11
Cluster Quorom Resource and Cluster Name
1.11.1
For Microsoft SQL Server 2005
1.12
Cluster Resources
1.12.1
For Microsoft SQL Server 2005
1.13
Cluster Resource and Group
1.13.1
For Microsoft SQL Server 2005
1.14
Cluster Resource and Type
1.14.1
For Microsoft SQL Server 2005
1.15
Cluster Resource Group and Cluster Name Metrics
1.15.1
For Microsoft SQL Server 2005
1.16
Cluster Resource and Owner Node Name
1.16.1
For Microsoft SQL Server 2005
1.17
Cluster Resource and Cluster Name
1.17.1
For Microsoft SQL Server 2005
1.18
Cluster Resource Group and Preferred Node
1.18.1
For Microsoft SQL Server 2005
1.19
Configuration Metrics
1.19.1
SQL Server Configuration Metrics
1.19.2
Registry Setting Configuration Metrics
1.19.3
Database Setting Configuration Metrics
1.19.4
HADR Availability Group Databases Metrics
1.20
Connection Statistics
1.21
Database
1.22
Database Backup
1.23
Database IOPS Metrics
1.24
Database Job
1.25
Database Lock
1.26
Database Parameter
1.27
Database Performance
1.27.1
For Microsoft SQL Server 2005/2008/2012
1.28
Database Status
1.29
Detailed Response
1.30
Event Log Entry
1.31
General Statistics
1.31.1
For Microsoft SQL Server 2005/2008/2012
1.32
HADR Availability Groups
1.33
HADR Availability Group Replicas
1.34
HADR Cluster Members
1.35
Index/Table Fragmentation Metrics
1.36
Index Usage
1.37
Last Database Backup
1.38
Latches
1.39
Latch Wait Time
1.40
Login
1.41
Memory Manager
1.41.1
For Microsoft SQL Server 2005/2008/2012
1.42
Memory Statistics
1.43
Memory Usage
1.44
Mirroring Monitoring
1.45
Mirroring Statistics
1.46
Missing Indexes
1.47
MSSQL Database File
1.48
MSSQL File Group
1.49
MSSQL Transaction Log
1.50
Processor
1.51
Response
1.52
Server Statistics Metrics
1.53
Space Usage
1.54
SQL Cluster Nodes Information
1.55
SQL Cluster Number of Nodes
1.56
SQL Instance Statistics
1.57
SQL Server Process Statistics
1.58
SQL Server Backups
1.59
SQL Server Locks
1.59.1
For Microsoft SQL Server 2005/2008/2012
1.60
SQL Server Process
1.61
SQL Server Role
1.62
SQL Statistics
1.62.1
For Microsoft SQL Server 2005/2008/2012
1.63
Top Queries by CPU Time Metrics
1.64
Top Queries by Execution Count
1.65
Top Queries by Total Blocked Time
1.66
Top Sessions by CPU Utilization
1.67
Top Sessions by Memory Utilization
1.68
User
1.69
Windows Cluster Name
1.69.1
For Microsoft SQL Server 2005
1.70
Windows Cluster Nodes
1.70.1
For Microsoft SQL Server 2005
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
Scripting on this page enhances content navigation, but does not change the content in any way.