List of data types

The following table lists the data types for field values and the corresponding C and C++ data types. The values in the Format column of the record field tables have the types shown below in the Field column under Data type.

Table 5-5 List of summary rules

Data typeByteDescription
FieldC and C++
char(n)char( )Number in parenthesesCharacter data of n bytes.
doubledouble8Numeric value (1.7E[Figure]308 (15 digits))
longlong4Numeric value (-2,147,483,648 to 2,147,483,647)
string(n)char[ ]Number in parenthesesCharacter string of n bytes.
  • Japanese Windows:
    Shift-JIS characters can be set.
  • Simplified-Chinese Windows:
    GB18030 characters can be set#.
  • Other Windows:
    Only 7-bit ASCII characters can be set.
The last character is null.
time_tunsigned long4Numeric value (0 to 4,294,967,295)
timevalStructure8Numeric value (first 4 bytes are seconds, next 4 bytes are microseconds)
ulongunsigned long4Numeric value (0 to 4,294,967,295)
utimeStructure8Numeric value (first 4 bytes are seconds, next 4 bytes are microseconds)
wordunsigned short2Numeric value (0 to 65,535)
(Not applicable)unsigned char1Numeric value (0 to 255)
#
In Simplified-Chinese Windows environment, database name of monitoring target SQL Server don't use out of range of GBK. If you use out of range of GBK in database name, PFM - RM for SQL Server collect performance data fail. In this case, "KAVL19812-E" is output by agent log error file (detail information: rc=0x80040e37, msg include "?").