Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


1.1.2 Collecting Microsoft SQL Server performance data

PFM - RM for Microsoft SQL Server enables you to collect performance data (statistical data such as the usage ratio of the database space and the cache hit rate) on the current Microsoft SQL Server session on the host being monitored.

Note
  • Performance data containing characters other than Shift-JIS (for Japanese Windows) or GB18030 (for Simplified-Chinese Windows) or 7-bit ASCII(for other Windows) cannot be collected in PFM - RM for Microsoft SQL Server.

  • PFM - RM for Microsoft SQL Server collects performance data of the record field size from Microsoft SQL Server. Therefore, if Microsoft SQL Server contains data that exceeds the field size, the last character of the performance data might be unreadable. The following table lists the applicable fields:

    Table 1‒1: Field of the performance data might be unreadable

    Recode name

    Field name

    Instance Availability (PD_IA)

    Message

    Lock Detail (PD_LD)

    User

    Process Detail (PD_PDET)

    User

With PFM - RM for Microsoft SQL Server, you can use the collected performance data as follows: