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-10 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.
Table 5-10 List of records for PFM - RM for Microsoft SQL Server
Record name | Record ID | Information stored in record |
---|---|---|
Config Detail | PD_CD | Information related to Microsoft SQL Server environment setting option |
Database Detail | PD_DD | Database information (snapshot), such as the numbers of locks and processes related to a particular database |
Database Space Detail | PD_DS | Information related to the size of the disk space used by a particular database |
Global Server Summary | PI | Information related to Microsoft SQL Server I/O, network, and so on |
Global Server Summary 2 | PI_PI2 | Information related to Microsoft SQL Server I/O, network, and so on |
Instance Availability | PD_IA | Information on the availability of the Microsoft SQL Server instance |
Lock Detail | PD_LD | Detailed information related to database locks |
Process Detail | PD_PDET | Detailed information on a particular database process, such as locks and I/O |
Server Detail | PD | Detailed information on Microsoft SQL Server, such as locks and I/O |
Server Locks Detail | PD_LOCK | Information related to Microsoft SQL Server locks |
Server Overview | PI_SERV | Overall information related to Microsoft SQL Server, such as the rate of cache hits and I/O |
Server Overview 2 | PI_SRV2 | Overall information related to Microsoft SQL Server, such as the rate of cache hits and I/O |
Server Space Detail | PD_SS | Information related to the size of the disk space used by Microsoft SQL Server |
Server Space Interval | PI_SI | Interval information related to the size of the disk space used by Microsoft SQL Server |
Transaction Log Overview | PI_TLOG | 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 |