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 |