List of records for PFM - Agent for Microsoft SQL Server

This section lists the records that can be collected by PFM - Agent for Microsoft SQL Server.

Table 5-10 lists the records that can be collected by PFM - Agent 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‒9: List of records for PFM - Agent 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 Interval	PI_DI	Interval information, such as the status related to a particular database
Database Replication Detail	PD_RD	Replication information of a particular database
Database Space Detail	PD_DS	Information related to the size of the disk space used by a particular database
Errorlog Error Detail	PD_EE	Detailed information related to the errors that occurred in Microsoft SQL Server This record is supported in Japanese, English and Chinese Windows environments only.
Errorlog Summary Detail	PD_ES	Summary of the errors that occurred in Microsoft SQL Server This record is supported in Japanese, English and Chinese Windows environments only.
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
Job History Detail	PD_JH	Job history information incorporated into the Microsoft SQL Server schedule
Licensing Detail	PD_LIC	Licensing information, such as the maximum number of Microsoft SQL Server connections allowed
Lock Detail	PD_LD	Detailed information related to database locks
Procedure Cache Detail	PD_PCAC	Information related to the procedure cache
Process Detail	PD_PDET	Detailed information on a particular database process, such as locks and I/O
Replication Published Database Overview	PI_RPDB	Replication information related to database distribution transactions and so on
Replication Summary Detail	PD_RS	Summary of database replication generated by Microsoft SQL Server
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
SQL Text	PD_SQL	This record displays the execution information on the last query issued by the process
Transaction Log Overview	PI_TLOG	Information related to transaction log space
User-Defined Counter Overview	PI_UCTR	Information related to each user-defined counter
User Process Detail	PD_USER	Information related to each logged-on user
Errorlog Summary Interval	PI_ESI	This record is reserved and cannot be used.
Generic Data Detail	PD_GEND
Generic Data Interval	PI_GENI
Restore History Detail	PD_RH
SQL Text - Performance-Based	PD_PDES

To Page Top