Notes on records

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 - RM for Microsoft SQL Server cannot collect the performance data to be stored in a field that is defined as an ODBC key field.

  • PFM - RM for Microsoft SQL Server cannot collect the performance data to be stored in a field that shows Microsoft SQL Server performance.

• Records with empty fields are generated

  In the following cases, records with empty fields are generated:

  • PFM - RM for Microsoft SQL Server cannot collect data of the character type.

  • PFM - RM for Microsoft SQL Server collects empty data of the character type.

  • Mirror databases exist on the monitoring-target Microsoft SQL Server host (because PFM - RM for Microsoft SQL Server cannot collect performance data from mirror databases).

• Records with a field value of -1 are generated

  When PFM - RM 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 - RM for Microsoft SQL Server collects data for a field that is defined in the data model, but whose data is not defined.

  • PFM - RM for Microsoft SQL Server cannot collect data for a field defined in the data model.

To Page Top

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_SS record

• PI_SI record

#

If the version of the monitoring-target Microsoft SQL Server is 2005 with SP1 or later or 2008, PFM - RM for Microsoft SQL Server can collect performance data from all the databases except offline databases.

To Page Top

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 - RM for Microsoft SQL server collects the records next time, PFM - RM for Microsoft SQL Server reestablish the connection to the Microsoft SQL Server and then start collecting the records.

To Page Top

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

  • 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:

  • Lock Detail (PD_LD) record

• If a failover occurs during collection of information for PFM ? RM 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 KAVL19812-E to the agent log:

  • Database Detail (PD_DD) record

  • Database Space Detail (PD_DS) 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.

• If the monitoring target is Microsoft SQL Server 2008, the following records do not reflect the data size of the FILESTREAM data and if the monitoring target is Microsoft SQL Server 2012 or later, the following records do not reflect the data size of the FileTable function data:

  • Database Space Detail (PD_DS) record

  • Server Space Detail (PD_SS) record

  • Server Space Interval (PI_SI) record

  • Transaction Log Overview (PI_TLOG) record

To Page Top