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
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:
- Real-time 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.
- Historical reports
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.