Properties and Performance Monitor statistics

Following is a list of enhancements made to properties and Performance Monitor statistics in SQL Anywhere version 12.0.0.

  • Connection properties   The following connection properties have been added in this release:

    • blocking_others_timeout
    • http_connection_pool_basesize
    • http_connection_pool_timeout
    • ParentConnection
    • Progress
    • progress_messages
    • QueryRowsFetched
    • reserved_keywords
    • st_geometry_asbinary_format
    • st_geometry_astext_format
    • st_geometry_asxml_format
    • st_geometry_describe_type
    • st_geometry_on_invalid
    • timestamp_with_time_zone_format

    For more information about these properties, see Accessing connection property values.

  • Database properties   The following database properties have been added in this release:

    • ConnPoolCachedCount
    • ConnPoolHits
    • ConnPoolMisses
    • DriveBus
    • DriveModel
    • HasTornWriteFix
    • HttpConnPoolCachedCount
    • HttpConnPoolHits
    • HttpConnPoolMisses
    • HttpConnPoolSteals
    • LastCheckpointTime
    • MirrorRole
    • QueryRowsFetched
    • SynchronizationSchemaChangeActive
    • WriteChecksums

    For more information about these properties, see Accessing database property values.

  • Database server properties   The following database server properties have been added in this release:

    • AutoMultiProgrammingLevel
    • AutoMultiProgrammingLevelStatistics
    • CurrentMultiProgrammingLevel
    • IPAddressMonitorPeriod
    • IsPortableDevice
    • MaxMultiProgrammingLevel
    • MinMultiProgrammingLevel
    • ObjectType
    • ThreadDeadlocksAvoided
    • ThreadDeadlocksReported

    For more information about these properties, see Accessing database server property values.