Job Management Partner 1 Version 10
Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
3021-3-352(E)
Contents
- Notices
- Preface
- Part 1: Overview
- 1. Overview of PFM - RM for Microsoft SQL Server
- 1.1 Features of PFM - RM for Microsoft SQL Server
- 1.1.1 Monitor the multiple target hosts agentlessly
- 1.1.2 Collecting Microsoft SQL Server performance data
- 1.1.3 Collecting performance data based on its characteristics
- 1.1.4 Saving performance data
- 1.1.5 Notifying users of problems in Microsoft SQL Server operation
- 1.1.6 Easy definition of alarms and reports
- 1.1.7 Operation with a cluster system
- 1.2 Overview of collection and management of performance data
- 1.3 Example of performance monitoring using PFM - RM for Microsoft SQL Server
- Part 2: Configuration and Operations
- 2. Installation and Setup
- 2.1 Installation and setup
- 2.2 Setup cancellation and uninstallation
- 2.3 Changing the system configuration of PFM - RM for Microsoft SQL Server
- 2.4 Changing the operation of PFM - RM for Microsoft SQL Server
- 2.5 Failover in the mirroring configuration
- 2.6 Monitoring in the SQL Server AlwaysOn Availability Group configuration
- 2.7 Backup and restoration
- 2.8 Online manuals
- 3. Operating PFM - RM for Microsoft SQL Server in a Cluster System
- 3.1 Cluster system overview
- 3.2 Processing during failover
- 3.3 Installation and setup
- 3.4 Setup cancellation and uninstallation
- 3.5 Changing the system configuration of PFM - RM for Microsoft SQL Server
- 3.6 Changing the operation of PFM - RM for Microsoft SQL Server
- 3.7 Notes on operating PFM - RM for Microsoft SQL Server in a cluster system
- Part 3: Reference
- 4. Monitoring Template
- Overview of the monitoring template
- Format of alarm explanations
- List of alarms
- Blocked Sessions
- Cache Usage
- CPU Usage
- Database Space
- Log Space Usage
- Network Error
- Server Status
- Format of report explanations
- Organization of report folders
- List of reports
- Blocked Sessions
- Blocking Locks
- Cache Usage
- Cache Usage Trend(Multi-Agent) (historical report past 24 hours)
- Cache Usage Trend(Multi-Agent) (historical report past month)
- CPU Usage - Top 10 Sessions
- Database Detail
- Database Space Usage
- Database Space Usage Detail
- Database Summary
- Lock Detail
- Lock Overview
- Lock Overview by Lock Type
- Lock Usage - Top 10 Sessions
- Log I/O Activity
- Log Space Usage - Top 10 Databases
- Memory Usage - Top 10 Sessions
- Network Activity
- Network Activity Trend (historical report past 24 hours)
- Network Activity Trend (historical report past month)
- Pending I/O
- Physical I/O - Top 10 Sessions
- Physical Write Activity
- Server Configuration Status
- Server CPU Trend (historical report past 24 hours)
- Server CPU Trend (historical report past month)
- Server Space Trend(Multi-Agent) (historical report past 24 hours)
- Server Space Trend(Multi-Agent) (historical report past month)
- Server Space Usage
- Session Detail
- Sessions
- System Overview
- 5. Records
- Data model
- Format of record explanations
- List of ODBC key fields
- Summary rules
- List of data types
- Field values
- Fields added only when data is stored in the Store database
- Fields output when data stored in the Store database is exported
- Notes on records
- List of records for PFM - RM for Microsoft SQL Server
- Config Detail (PD_CD)
- Database Detail (PD_DD)
- Database Space Detail (PD_DS)
- Global Server Summary (PI)
- Global Server Summary 2 (PI_PI2)
- Instance Availability (PD_IA)
- Lock Detail (PD_LD)
- Process Detail (PD_PDET)
- Server Detail (PD)
- Server Locks Detail (PD_LOCK)
- Server Overview (PI_SERV)
- Server Overview 2 (PI_SRV2)
- Server Space Detail (PD_SS)
- Server Space Interval (PI_SI)
- Transaction Log Overview (PI_TLOG)
- 6. Messages
- 6.1 Message format
- 6.2 Message output destinations
- 6.3 Messages output to the Windows event log
- 6.4 Messages
- Part 4: Troubleshooting
- 7. Error Handling Procedures
- 7.1 When an error occurs
- 7.2 Troubleshooting procedures
- 7.3 Log information
- 7.4 Required troubleshooting information
- 7.5 Collecting troubleshooting information
- 7.6 Detecting errors in Performance Management
- 7.7 Recovering from errors in Performance Management system
- Appendixes
- A. Estimating System Requirements
- B. List of Identifiers
- C. List of Processes
- D. List of Port Numbers
- E. PFM - RM for Microsoft SQL Server Properties
- F. List of Files and Folders
- G. Migration Procedure and Notes on Migration
- H. Version Compatibility
- I. Deleting the R4QHITACHIPROCSPDATABASES Stored Procedure
- J. Outputting Action Log Information
- K. Linking with JP1/ITSLM
- L. About Communication in IPv4 Environments and IPv6 Environments
- M. Version Revisions
- N. Reference Material for This Manual
- O. Glossary
- Index
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.