List of records for PFM - RM for Microsoft SQL Server
This section lists the records that can be collected by PFM - RM for Microsoft SQL Server.
Table 5-9 lists the records that can be collected by PFM - RM for Microsoft SQL Server and the information that is stored in each record. The records in the following table are listed in order of record name, respectively.
Record name |
Record ID |
Information stored in record |
---|---|---|
Information related to Microsoft SQL Server environment setting option |
||
Database information (snapshot), such as the numbers of locks and processes related to a particular database |
||
Information related to the size of the disk space used by a particular database |
||
Information related to Microsoft SQL Server I/O, network, and so on |
||
Information related to Microsoft SQL Server I/O, network, and so on |
||
Information on the availability of the Microsoft SQL Server instance |
||
Detailed information related to database locks |
||
Detailed information on a particular database process, such as locks and I/O |
||
Detailed information on Microsoft SQL Server, such as locks and I/O |
||
Information related to Microsoft SQL Server locks |
||
Overall information related to Microsoft SQL Server, such as the rate of cache hits and I/O |
||
Overall information related to Microsoft SQL Server, such as the rate of cache hits and I/O |
||
Information related to the size of the disk space used by Microsoft SQL Server |
||
Interval information related to the size of the disk space used by Microsoft SQL Server |
||
Information related to transaction log space |
||
Errorlog Summary Interval |
PI_ESI |
This record is reserved and cannot be used. |
Errorlog Summary Interval |
PI_ESI |
|
Generic Data Detail |
PD_GEND |
|
Generic Data Interval |
PI_GENI |
|
Restore History Detail |
PD_RH |