HITACHI Inspire The Next

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
1.3.1 Determining a baseline
1.3.2 Insufficient data cache
1.3.3 CPU usage ratio per session
1.3.4 Insufficient log space
1.3.5 Insufficient database space
1.3.6 Increase in the number of locks
1.3.7 Network load
1.3.8 Instance validity
Part 2: Configuration and Operations
2. Installation and Setup
2.1 Installation and setup
2.1.1 Preparation for installing and setting up PFM - RM for Microsoft SQL Server
2.1.2 Installation and setup workflow
2.1.3 Installation procedure
2.1.4 Setting up PFM - RM for Microsoft SQL Server
2.2 Setup cancellation and uninstallation
2.2.1 Cautionary notes on setup cancellation and uninstallation
2.2.2 Procedure for canceling setup
2.2.3 Procedure for 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.4.1 Changing the storage location of performance data
2.4.2 Updating a monitoring target
2.4.3 Updating an instance environment
2.4.4 Checking how monitoring targets are configured
2.5 Failover in the mirroring configuration
2.5.1 Monitoring databases in the mirroring configuration
2.5.2 Monitoring while a failover occurs in databases in the mirroring configuration
2.5.3 Monitoring after a failover occurs in databases in the mirroring configuration
2.6 Monitoring in the SQL Server AlwaysOn Availability Group configuration
2.6.1 Monitoring during failover in the SQL Server AlwaysOn Availability Group configuration
2.6.2 Monitoring after failover in the SQL Server AlwaysOn Availability Group configuration
2.7 Backup and restoration
2.7.1 Backup
2.7.2 Restoration
2.8 Online manuals
2.8.1 Setting procedures
2.8.2 Viewing the manual
3. Operating PFM - RM for Microsoft SQL Server in a Cluster System
3.1 Cluster system overview
3.1.1 HA cluster system
3.1.2 Federated database server
3.2 Processing during failover
3.2.1 Failover when a failure occurs on a monitoring host
3.2.2 Failure occurs on PFM - RM for Microsoft SQL Server host
3.2.3 Effects when PFM - Manager stops
3.3 Installation and setup
3.3.1 Preparation for installation and setup
3.3.2 Installation and setup workflow
3.3.3 Installation procedure
3.3.4 Setup procedure
3.4 Setup cancellation and uninstallation
3.4.1 Setup cancellation and uninstallation workflow of PFM - RM for Microsoft SQL Server
3.4.2 Setup cancellation procedure
3.4.3 Uninstallation procedure
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.6.1 Updating a monitoring target
3.6.2 Updating an instance environment
3.6.3 Exporting and importing the logical-host environment definition file
3.7 Notes on operating PFM - RM for Microsoft SQL Server in a cluster system
3.7.1 Host name in the collected performance data
3.7.2 Log output for a cluster system
3.7.3 Timeout
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.1.1 Format of output messages
6.1.2 Format of message explanation
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.2.1 Problems relating to the start and setup of services
7.2.2 Problems relating to command execution
7.2.3 Problems relating to report definitions
7.2.4 Problems relating to alarm definitions
7.2.5 Problems relating to the collection and management of performance data
7.2.6 Other problems
7.3 Log information
7.3.1 Types of log information
7.3.2 List of log files and directories
7.4 Required troubleshooting information
7.4.1 In Windows
7.5 Collecting troubleshooting information
7.5.1 In Windows
7.6 Detecting errors in Performance Management
7.7 Recovering from errors in Performance Management system
Appendixes
A. Estimating System Requirements
A.1 Memory requirements
A.2 Disk space requirements
A.3 Disk space requirements for operation in a cluster system
A.4 Calculating the number of instances for records
B. List of Identifiers
C. List of Processes
D. List of Port Numbers
D.1 Port numbers for PFM - RM for Microsoft SQL Server
D.2 Routing through a firewall
E. PFM - RM for Microsoft SQL Server Properties
E.1 List of Remote Monitor Store service properties
E.2 List of Remote Monitor Collector service properties
E.3 List of remote agent and group agent properties
F. List of Files and Folders
F.1 PFM - RM for Microsoft SQL Server files and directories
G. Migration Procedure and Notes on Migration
H. Version Compatibility
I. Deleting the R4QHITACHIPROCSPDATABASES Stored Procedure
I.1 Procedure for deleting R4QHITACHIPROCSPDATABASES
J. Outputting Action Log Information
J.1 Event types output to the action log
J.2 Format for saving the action log files
J.3 Action log output format
J.4 Settings for outputting action logs
K. Linking with JP1/ITSLM
L. About Communication in IPv4 Environments and IPv6 Environments
M. Version Revisions
M.1 Revisions in 10-00
N. Reference Material for This Manual
N.1 Related publications
N.2 Conventions: Abbreviations for product names
N.3 Conventions: Acronyms
N.4 Conventions: Product names, service IDs, and service keys
N.5 Conventions: Installation folder
N.6 Supported NNM products
N.7 Conventions: KB, MB, GB, and TB
O. Glossary
Index