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
If the version of the monitoring-target Microsoft SQL Server is 2005 without SP1 or later, the following record collection from all the databases on the Microsoft SQL Server fails when any one of the databases which consist of the Microsoft SQL Server is turned offline. To collect the records listed below, turn online the databases you turned offline. #
-
PD_DD record
-
PD_DS record
-
PD_RD record
-
PD_RS record
-
PD_SS record
-
PI_DI record
-
PI_RPDB record
-
PI_SI record
- #
-
If the version of the monitoring-target Microsoft SQL Server is 2005 with SP1 or later, PFM - Agent for Microsoft SQL Server can collect performance data from all the databases except offline databases.
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.