1.1.1 Collecting Microsoft SQL Server performance data
PFM - Agent 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 - Agent for Microsoft SQL Server.
With PFM - Agent 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 - Agent 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 - Agent for Microsoft SQL Server.
-
-
As criteria for determining whether a problem has occurred
You can set PFM - Agent for Microsoft SQL Server to take some action (such as notifying the user) if collected performance data indicates an abnormal condition.