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