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:
-
To graphically display the operating status of Microsoft SQL Server
By using PFM - Web Console, you can process and display performance data in a graphical format called a report. A report facilitates the analysis of the Microsoft SQL Server operating status.
There are two types of reports:
-
A real-time report indicates the current status of a Microsoft SQL Server system being monitored. It is used primarily to check the current status of the system and to detect problems in the system. To display real-time reports, PFM - RM for Microsoft SQL Server uses current performance data that has just been collected.
-
A historical report indicates the status of a Microsoft SQL Server system being monitored from a selected point of time in the past to the present. It is used primarily to analyze trends in the system. To display a historical report, the system uses performance data that has been stored in a database for PFM - RM for Microsoft SQL Server.
-
-
As criteria for determining whether a problem has occurred
You can set PFM - RM for Microsoft SQL Server to take some action (such as notifying the user) if collected performance data indicates an abnormal condition.