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 nameRecord IDInformation stored in record
Config DetailPD_CDInformation related to Microsoft SQL Server environment setting option
Database DetailPD_DDDatabase information (snapshot), such as the numbers of locks and processes related to a particular database
Database Space DetailPD_DSInformation related to the size of the disk space used by a particular database
Global Server SummaryPIInformation related to Microsoft SQL Server I/O, network, and so on
Global Server Summary 2PI_PI2Information related to Microsoft SQL Server I/O, network, and so on
Instance AvailabilityPD_IAInformation on the availability of the Microsoft SQL Server instance
Lock DetailPD_LDDetailed information related to database locks
Process DetailPD_PDETDetailed information on a particular database process, such as locks and I/O
Server DetailPDDetailed information on Microsoft SQL Server, such as locks and I/O
Server Locks DetailPD_LOCKInformation related to Microsoft SQL Server locks
Server OverviewPI_SERVOverall information related to Microsoft SQL Server, such as the rate of cache hits and I/O
Server Overview 2PI_SRV2Overall information related to Microsoft SQL Server, such as the rate of cache hits and I/O
Server Space DetailPD_SSInformation related to the size of the disk space used by Microsoft SQL Server
Server Space IntervalPI_SIInterval information related to the size of the disk space used by Microsoft SQL Server
Transaction Log OverviewPI_TLOGInformation related to transaction log space
Errorlog Summary IntervalPI_ESIThis record is reserved and cannot be used.
Errorlog Summary IntervalPI_ESI
Generic Data DetailPD_GEND
Generic Data IntervalPI_GENI
Restore History DetailPD_RH