Notes on records
Note the following when collecting records.
- Organization of this page
Results of record generation when no data can be acquired
The following explains the results of record generation when no data can be acquired.
-
No records are generated
In the following cases, no records are generated:
-
PFM - Agent for Microsoft SQL Server cannot collect the performance data to be stored in a field that is defined as an ODBC key field.
-
PFM - Agent for Microsoft SQL Server cannot collect the performance data to be stored in a field that shows Microsoft SQL Server performance.
-
Mirror databases exist on the monitoring-target Microsoft SQL Server host (because PFM - Agent for Microsoft SQL Server cannot collect performance data from mirror databases).
-
-
Records with empty fields are generated
In the following cases, records with empty fields are generated:
-
PFM - Agent for Microsoft SQL Server cannot collect data of the character type.
-
PFM - Agent for Microsoft SQL Server collects empty data of the character type.
-
-
Records with a field value of -1 are generated
When PFM - Agent for Microsoft SQL Server cannot collect configuration data of the numeric type, records with a field value of -1 are generated.
-
Records with a field value of Unknown are generated
In the following cases, records with a field value of Unknown are generated:
-
PFM - Agent for Microsoft SQL Server collects data for a field that is defined in the data model, but whose data is not defined.
-
PFM - Agent for Microsoft SQL Server cannot collect data for a field defined in the data model.
-
Record collection fails when the monitoring database is online
In the record shown below, only information other than offline databases can be collected.
-
PD_DD record
-
PD_DS record
-
PD_RD record
-
PD_RS record
-
PD_SS record
-
PI_DI record
-
PI_RPDB record
-
PI_SI record
Results of record collection when the session to the monitoring-target Microsoft SQL Server is disconnected
If the session to the monitoring-target Microsoft SQL Server is disconnected, the record collection may fail. In this case, when PFM - Agent for Microsoft SQL server collects the records next time, PFM - Agent for Microsoft SQL Server reestablish the connection to the Microsoft SQL Server and then start collecting the records.
Precautions for collecting records
-
If the name of a database includes a single quotation mark (') or a double quotation mark ("), the following records are not displayed:
-
Database Detail (PD_DD) record
-
Database Space Detail (PD_DS) record
-
Server Space Detail (PD_SS) record
-
Database Interval (PI_DI) record
-
Server Space Interval (PI_SI) record
-
-
If the name of a database includes a single quotation mark (') or a double quotation mark ("), the following items are incorrectly displayed:
-
Articles field, Pubilcations field, Subscriptions field of Database Replication Detail (PD_RD) record
-
Lock Detail (PD_LD) record
-
-
If a failover occurs during collection of information for PFM - Agent for Microsoft SQL Server, the monitored Microsoft SQL Server might have a database that changes from a principal database to a mirror database. If Microsoft SQL Server has such a database, this product cannot collect information for the following records, and outputs message KAVF21812-E to the agent log:
-
Database Detail (PD_DD) record
-
Database Interval (PI_DI) record
-
Database Replication Detail (PD_RD) record
-
Database Space Detail (PD_DS) record
-
Replication Published Database Overview (PI_RPDB) record
-
Replication Summary Detail (PD_RS) record
-
Server Detail (PD) record
-
Server Space Detail (PD_SS) record
-
Server Space Interval (PI_SI) record
If the failover finishes before the next collection time, these records can be collected.
-
-
The data size stored by the FileTable function do not reflected in the following record:
-
Database Space Detail (PD_DS) record
-
Server Space Detail (PD_SS) record
-
Server Space Interval (PI_SI) record
-
Database Interval (PI_DI) record
-
Transaction Log Overview (PI_TLOG) record
-