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
- TempFilePages
- timestamp_with_time_zone_format
For more information about these properties, see Connection properties.
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 Database properties.
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 Database server properties.

Discuss this page in DocCommentXchange.