Properties and Performance Monitor statistics

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

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

    • allow_read_client_file
    • allow_write_client_file
    • AuthType
    • CacheReadWorkTable
    • ClientNodeAddress
    • DiskReadWorkTable
    • DiskSyncRead
    • DiskSyncWrite
    • DiskWaitRead
    • DiskWaitWrite
    • DiskWriteHint
    • DiskWriteHintPages
    • LockIndexID
    • LockRowID
    • max_priority
    • OSUser
    • priority
    • query_mem_timeout
    • QueryMemActiveCurr
    • QueryMemExtraAvail
    • QueryMemGrantFailed
    • QueryMemGrantGranted
    • QueryMemGrantWaiting
    • QueryMemGrantRequested
    • QueryMemWaited
    • ServerNodeAddress
    • ReadHint
    • ReadHintScatter

    For descriptions of these properties, see Connection properties.

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

    • DiskRetryRead
    • DiskRetryReadScatter
    • DiskRetryWrite
    • EventTypeDesc
    • EventTypeName
    • HttpAddresses
    • HttpsAddresses
    • HttpNumActiveReq
    • HttpNumConnections
    • HttpNumSessions
    • HttpsNumActiveReq
    • HttpsNumConnections
    • MaxEventType
    • MaxRemoteCapability
    • MessageCategoryLimit
    • OptionWatchAction
    • OptionWatchList
    • QueryMemActiveCurr
    • QueryMemActiveEst
    • QueryMemActiveMax
    • QueryMemExtraAvail
    • QueryMemGrantBase
    • QueryMemGrantBaseMI
    • QueryMemGrantExtra
    • QueryMemGrantFailed
    • QueryMemGrantGranted
    • QueryMemGrantWaiting
    • QueryMemGrantRequested
    • QueryMemPages
    • QueryMemPercentOfCache
    • QueryMemWaited
    • ReadHintScatterLimit
    • RemoteCapability
    • StreamsUsed
    • TcpIpAddresses
    • WebClientLogFile
    • WebClientLogging

    For descriptions of these properties, see Database server properties.

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

    • AlternateMirrorServerName
    • CacheReadWorkTable
    • DiskReadWorkTable
    • DiskRetryReadScatter
    • DiskSyncRead
    • DiskSyncWrite
    • DiskWaitRead
    • DiskWaitWrite
    • DiskWriteHint
    • DiskWriteHintPages
    • HasEndianSwapFix
    • MirrorMode
    • ReadHint
    • ReadHintScatter

    For descriptions of these properties, see Database properties.

  • New Performance Monitor statistics   The following Performance Monitor statistics have been added in this release:

    • Cache Reads: Work Table
    • Disk Reads: Work Table