Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties

List of connection properties

Connection properties are available for each connection to a database. Connection property names are case insensitive. Use the CONNECTION_PROPERTY system function or the sa_conn_properties system procedure to retrieve connection properties.

Example

The following statement returns the number of pages that have been read from file by the current connection.

SELECT CONNECTION_PROPERTY ( 'DiskRead' );

Use the sa_conn_properties system procedure to retrieve the values of all connection properties:

CALL sa_conn_properties( );
Connection properties

Property name

Description

allow_nulls_by_default

Whether columns created without specifying either NULL or NOT NULL are allowed to contain NULL values. This property corresponds to the allow_nulls_by_default option for the connection.

allow_read_client_file

Whether the database server allows the reading of files on a client computer. This property corresponds to the allow_read_client_file option for the connection.

allow_snapshot_isolation

Whether snapshot isolation is enabled or disabled. This property corresponds to the allow_snapshot_isolation option for the connection.

allow_write_client_file

Whether the database server allows the writing of files to a client computer. This property corresponds to the allow_write_client_file option for the connection.

ansi_blanks

Indicates when character data is truncated at the client side. This property corresponds to ansi_blanks option for the connection.

ansi_close_cursors_on_rollback

Whether cursors opened WITH HOLD are closed when a ROLLBACK is performed. This property corresponds to the ansi_close_cursors_on_rollback option for the connection.

ansi_permissions

Whether privileges are checked for DELETE and UPDATE statements. This property corresponds to the ansi_permissions option for the connection.

ansi_substring

The behavior of the SUBSTRING (SUBSTR) function when negative values are provided for the start or length parameters. This property corresponds to the ansi_substring option for the connection.

ansi_update_constraints

The range of updates that are permitted. This property corresponds to the ansi_update_constraints option for the connection.

ansinull

How NULL values are interpreted. This property corresponds to the ansinull option.

AppInfo

Information about the client that made the connection. For HTTP connections, this includes information about the browser. For connections using older versions of SAP Open Client or jConnect, the information may be incomplete.

ApproximateCPUTime

The estimate of the amount of CPU time accumulated by a given connection, in seconds. The value returned may differ from the actual value by as much as 50%, although typical variations are in the 5-10% range. On multi-processor computers, each CPU (or hyperthread or core) accumulates time, so the sum of accumulated times for all connections may be greater than the elapsed time.

audit_log

The location where audit logs are directed.

auditing

Whether auditing is enabled for the database(On) or not (Off). This option corresponds to the auditing option.

auditing_options

This property is reserved for system use.

Authenticated

Whether the application sent a valid connection authentication string (Yes) or not (No).

AuthType

The type of authentication used when connecting. The value returned is one of Standard, Integrated, Kerberos, LDAPUA, CloudAdmin,or an empty string. The value is an empty string when the connection is an internal connection or for connections for HTTP services that use AUTHORIZATION OFF.

auto_commit

Whether the database server automatically commits after each statement. By default, the database server operates in manual commit mode. To turn on automatic commits, set the auto_commit database option (a server-side option). Do not confuse this option with the Interactive SQL option of the same name.

auto_commit_on_create_local_temp_index

Whether the database server performs a COMMIT before an index is created on a local temporary table. This property corresponds to the value of the auto_commit_on_create_local_temp_index option.

background_priority

This property is deprecated. The value of the background_priority option for the connection, which indicates how much impact the current connection has on the performance of other connections.

BlockedOn

Whether the current connection is blocked or not (zero). When the connection is blocked because of a locking conflict, the value is the connection number on which the connection is blocked.

blocking

The database server's behavior in response to locking conflicts. This property corresponds to the blocking option for the connection.

blocking_others_timeout

The length of time that another connection can block on the current connection's row and table locks before the current connection is rolled back. This property corresponds to the value of the blocking_others_timeout option.

blocking_timeout

The length of time, in milliseconds, a transaction waits to obtain a lock. This property corresponds to the blocking_timeout option.

BytesReceived

The number of bytes received during client/server communications. This value is updated for HTTP and HTTPS connections.

BytesReceivedUncomp

The number of bytes that would have been received during client/server communications if compression was disabled. This value is the same as the value for BytesReceived if compression is disabled.

BytesSent

The number of bytes sent during client/server communications. This value is updated for HTTP and HTTPS connections.

BytesSentUncomp

The number of bytes that would have been sent during client/server communications if compression was disabled. This value is the same as the value for BytesSent if compression is disabled.

CacheHits

The number of successful reads of the cache.

CacheRead

The number of database pages that have been looked up in the cache.

CacheReadIndInt

The number of index internal-node pages that have been read from the cache.

CacheReadIndLeaf

The number of index leaf pages that have been read from the cache.

CacheReadTable

The number of table pages that have been read from the cache.

CacheReadWorkTable

The number of cache work table reads.

CarverHeapPages

The number of heap pages used for short-term purposes such as query optimization.

chained

The value of the chained option, which indicates the transaction mode used in the absence of a BEGIN TRANSACTION statement.

CharSet

The CHAR character set used by the connection. This property has extensions that you can specify when querying the property value.

checkpoint_time

The value of the checkpoint_time option, which indicates the maximum time, in minutes, that the database server runs without doing a checkpoint.

cis_option

Specifies 7 if debugging information for remote data access appears in the database server messages window. Specifies 0 if the debugging information for remote data access does not appear in the database server messages window. This property corresponds to the cis_option option.

cis_rowset_size

The number of rows that are returned from remote servers for each fetch. This property corresponds to the value of the cis_rowset_size option.

ClientLibrary

The connection library type. The value is jConnect for jConnect connections; CT_Library for SAP Open Client connections; None for HTTP connections, and CmdSeq for ODBC, Embedded SQL, OLE DB, ADO.NET, and SQL Anywhere JDBC driver connections.

ClientNodeAddress

The node for the client in a client/server connection. When the client and server are both on the same computer, an empty string is returned. This property is a synonym for the NodeAddress property.

The value is NA if the request that is currently executing is part of an event handler.

ClientPort

The client's TCP/IP port number or 0 if the connection isn't a TCP/IP connection.

ClientStmtCacheHits

The number of prepares that were not required for this connection because of the client statement cache. This value is the number of additional prepares that would be required if client statement caching was disabled.

ClientStmtCacheMisses

The number of statements in the client statement cache for this connection that were prepared again. This value is the number of times a cached statement was considered for reuse, but could not be reused because of a schema change, a database option setting, or a DROP VARIABLE statement.

close_on_endtrans

Whether cursors are closed at the end of a transaction. This property corresponds to the close_on_endtrans option.

collect_statistics_on_dml_updates

Whether statistics are gathered during the execution of data-altering DML statements such as INSERT, DELETE, and UPDATE. This property corresponds to the collect_statistics_on_dml_updates option.

Commit

The number of Commit requests that have been handled.

CommLink

The communication link for the connection. The value is one of the supported network protocols supported, or local for a same-computer connection. The value is NA if the request that is currently executing is part of an event handler.

CommNetworkLink

The communication link for the connection. This value returned is one of the supported network protocols. Values include SharedMemory and TCPIP. The value always includes the name of the link, regardless of whether it is same-computer or not. The value is NA if the request that is currently executing is part of an event handler.

CommProtocol

The communication protocol. The value is TDS for SAP Open Client and jConnect connections, HTTP for HTTP connections, HTTPS for HTTPS connections. The value is CmdSeq for ODBC, Embedded SQL, OLE DB, ADO.NET, and SQL Anywhere JDBC driver connections.

Compression

Whether communication compression is enabled on the connection. The value is NA if the request that is currently executing is part of an event handler.

conn_auditing

Whether auditing is enabled or disabled for the connection when the auditing option is also set to On. This property corresponds to the conn_auditing option.

ConnectedTime

The total length of time, in seconds, that a connection has been connected.

connection_authentication

The string used to authenticate the client. Authentication is required before the database can be modified. This property corresponds to the connection_authentication option.

connection_type

The value of the connection_type database option: one of: Event, Internal, Standard, or Monitor

continue_after_raiserror

Whether execution of a procedure or trigger is stopped whenever the RAISERROR statement is encountered. This property corresponds to the continue_after_raiserror option

conversion_error

Whether data type conversion failures are reported when fetching information from the database This property corresponds to the value of the conversion_error option.

cooperative_commit_timeout

This property is deprecated. The value of the cooperative_commit_timeout option, which is the time, in milliseconds, that the database server waits for other connections to fill a page of the log before writing to disk.

cooperative_commits

This property is deprecated. The value of the cooperative_commits option, which is On or Off to indicate when commits are written to disk.

CurrentLineNumber

The current line number of the procedure or compound statement a connection is executing. The procedure can be identified using the CurrentProcedure property. If the line is part of a compound statement from the client, an empty string is returned.

CurrentProcedure

The name of the procedure that a connection is currently executing. If the connection is executing nested procedure calls, the name is the name of the current procedure. If there is no procedure executing, an empty string is returned.

Cursor

The number of declared cursors that are currently being maintained by the database server.

CursorOpen

The number of open cursors that are currently being maintained by the database server.

database_authentication

Indicates the string used to authenticate the database. Authentication is required for authenticated database servers before the database can be modified. This property corresponds to the database_authentication option

date_format

The value of the date_format option, which is a string indicating the format for dates retrieved from the database.

date_order

The value of the date_order option, which is a string indicating how dates are formatted.

DBNumber

The ID number of the database.

db_publisher

The user ID of the database publisher. This property corresponds to the db_publisher option.

debug_messages

Whether MESSAGE statements that include a DEBUG ONLY clause are executed. This property corresponds to the debug_messages option

dedicated_task

Whether a request handling task is dedicated exclusively to handling requests for the connection. This property corresponds to the dedicated_task option

default_dbspace

The name of the default dbspace, or an empty string if the default dbspace has not been specified. This property corresponds to the default_dbspace option,

default_timestamp_increment

The number of microseconds that is added to a column of type TIMESTAMP to keep values in the column unique. This property corresponds to the default_timestamp_increment.

delayed_commit_timeout

The time, in milliseconds, that the database server waits to return control to an application following a COMMIT. This property corresponds to the delayed_commit_timeout option.

delayed_commits

Whether the database server returns control to an application following a COMMIT or not. This property corresponds to the delayed_commits option.

DiskRead

The number of pages that have been read from disk.

DiskReadHint

The number of disk read hints.

DiskReadHintPages

The number of disk read hint pages.

DiskReadIndInt

The number of index internal-node pages that have been read from disk.

DiskReadIndLeaf

The number of index leaf pages that have been read from disk.

DiskReadTable

The number of table pages that have been read from disk.

DiskReadWorkTable

The number of disk work table reads.

disk_sandbox

Whether the read-write file operations of the database are restricted to the directory where the main database file is located. This property corresponds to the disk_sandbox option.

DiskSyncRead

The number of disk reads issued synchronously.

DiskSyncWrite

The number of writes issued synchronously.

DiskWaitRead

The number of times the database server waited for an asynchronous read.

DiskWaitWrite

The number of times the database server waited for an asynchronous write.

DiskWrite

The number of modified pages that have been written to disk.

DiskWriteHint

The number of disk write hints.

DiskWriteHintPages

The number of disk write hint pages.

divide_by_zero_error

Whether if division by zero results in an error (On) or not (Off). This property corresponds to the divide_by_zero_error option.

Encryption

Whether the connection is encrypted or not

escape_character

This property is reserved for system use. Do not change the setting of this option.

EventName

The name of the associated event if the connection is running an event handler. Otherwise, an empty string is returned.

exclude_operators

This property is reserved for system use. Do not change the setting of this option.

ExprCacheAbandons

The number of times that the expression cache was abandoned because the hit rate was too low.

ExprCacheDropsToReadOnly

The number of times that the expression cache dropped to read-only status because the hit rate was low.

ExprCacheEvicts

The number of evictions from the expression cache.

ExprCacheHits

The number of hits in the expression cache.

ExprCacheInserts

The number of values inserted into the expression cache.

ExprCacheLookups

The number of lookups done in the expression cache.

ExprCacheResumesOfReadWrite

The number of times that the expression cache resumed read-write status because the hit rate increased.

ExprCacheStarts

The number of times that the expression cache was started.

extern_login_credentials

Whether remote connections are attempted using the logged in user's external login credentials or the effective user's external login credentials. This property corresponds to the extern_login_credentials option.

extended_join_syntax

Whether queries with duplicate correlation name syntax for multi-table joins are allowed, or whether they are reported as errors. This property corresponds to the extended_join_syntax option.

fire_triggers

Whether triggers are fired in the database. This property corresponds to the fire_triggers option.

first_day_of_week

The number that is used for the first day of the week, where 7=Sunday and 1=Monday. This property corresponds to the first_day_of_week option.

for_xml_null_treatment

The value is Omit if elements and attributes that contain NULL values are omitted from the result. The value is Empty if empty elements or attributes are generated for NULL values when the FOR XML clause is used in a query. This property corresponds to the for_xml_null_treatment option.

force_view_creation

This property is reserved for system use. Do not change the setting of this option.

FullCompare

The number of comparisons that have been performed beyond the hash value in an index.

GetData

The number of GETDATA requests.

global_database_id

The starting value used for columns created with DEFAULT GLOBAL AUTOINCREMENT. This property corresponds to the global_database_id option.

HashForcedPartitions

The number of times that a hash operator was forced to partition because of competition for memory.

HashRowsFiltered

The number of probe rows rejected by bit-vector filters.

HashRowsPartitioned

The number of rows written to hash work tables.

HasSecuredFeature

Whether at least one feature of the feature set is secured (Yes) or not (No). This property has extensions that you can specify when querying the property value.

HashWorkTables

The number of work tables created for hash-based operations.

HeapsCarver

The number of heaps used for short-term purposes such as query optimization.

HeapsLocked

The number of relocatable heaps currently locked in the cache.

HeapsQuery

The number of heaps used for query processing (hash and sort operations).

HeapsRelocatable

The number of relocatable heaps.

http_connection_pool_basesize

The nominal threshold size of database connections. This property corresponds to the http_connection_pool_basesize option.

http_connection_pool_timeout

The maximum length of time that unused connections are stored in the connection pool. This property corresponds to the http_connection_pool_timeout option.

http_session_timeout

The current HTTP session timeout, in minutes. This property corresponds to http_session_timeout option.

HttpServiceName

The service name entry point for the current HTTP request. This property is useful for error reporting and flow control. An empty string is returned when this property is selected from a stored procedure that did not originate from an HTTP request or if the connection is currently inactive or waiting to continue an HTTP session.

IdleTimeout

The idle timeout value of the connection. The value is NA if the request that is currently executing is part of an event handler.

IndAdd

The number of entries that have been added to indexes.

IndLookup

The number of entries that have been looked up in indexes.

integrated_server_name

The name of the Domain Controller server used for looking up Windows user group membership for integrated logins. This property corresponds to the integrated_server_name option.

IsDebugger

Whether the connection is being used to run the debugger (Yes) or not (No). The value is Yes if the current connection number corresponds to the connection number of a debugger connection, and No otherwise.

isolation_level

The isolation level of the connection. This property corresponds to the isolation_level option.

java_class_path

The list of additional directories or JAR files that are searched for classes. This property corresponds to the java_class_path option.

java_location

The path of the Java VM for the database if one has been specified. This property corresponds to the java_location option.

java_vm_options

The command line options that the database server uses when it launches the Java VM. This property corresponds to the java_vm_options option.

java_main_userid

This property is deprecated.

Language

The locale language.

LastCommitRedoPos

The redo log position after the last COMMIT operation was written to the transaction log by the connection.

LastIdle

The number of ticks between requests.

LastPlanText

The long text plan of the last query executed on the connection. You control the remembering of the last plan by setting the RememberLastPlan option of the sa_server_option system procedure, or using the -zp server option.

LastReqTime

The time at which the last request for the specified connection started, in the timezone of the database. This property can return an empty string for internal connections, such as events. If the database has the time_zone option set, then the value is returned using the database's time zone.

LastStatement

The most recently prepared SQL statement for the current connection. The LastStatement value is set when a statement is prepared, and is cleared when a statement is dropped. Only one statement string is remembered for each connection. When client statement caching is enabled and a cached statement is reused, the value is an empty string. If sa_conn_activity reports a non-empty value for a connection, it is most likely the statement that the connection is currently executing. If the statement had completed, it would likely have been dropped and the property value would have been cleared. If an application prepares multiple statements and retains their statement handles, then the LastStatement value does not reflect what a connection is currently doing.

LivenessTimeout

The liveness timeout period for the current connection. The value is NA if the request that is currently executing is part of an event handler.

lock_rejected_rows

This property is reserved for system use. Do not change the setting of this option.

LockCount

The number of locks held by the connection.

LockObjectOID

The value is zero if the connection isn't blocked on a table, mutex, or a semaphore, or if the connection is on a different database than the connection calling CONNECTION_PROPERTY. Otherwise, LockObjectOID is the object ID of the table, permanent mutex, or permanent semaphore that the connection is blocked on. A negative value indicates the ID of a temporary mutex or semaphore. LockObjectOID can be used to look up information about temporary mutexes and semaphores using the sp_list_mutexes_semaphores system procedure. If the object is a table, LockObjectOID can be used to look up table information using the SYSTAB system view.

LockObjectType

The ID for the type of object the connection is blocked on. Use the ID to look up the object type in the SYSOBJECT view. Can be one of 'TABLE' or 'MUTEX SEMAPHORE'.

LockIndexID

The identifier of the locked index.

LockName

The 64-bit unsigned integer value representing the lock for which a connection is waiting.

LockRowID

The identifier of the locked row.

LockTableOID

Zero if the connection isn't blocked, or isn't blocked on a table, or if the connection is on a different database than the connection calling CONNECTION_PROPERTY. Otherwise, this is the object ID of the table for the lock on which this connection is waiting. The object ID can be used to look up table information using the SYSTAB system view.

log_deadlocks

Whether deadlock information is recorded (On) or not (Off). This property corresponds to the log_deadlocks option.

LogFreeCommit

The number of redo free commits. A redo free commit occurs when a commit of the transaction log is requested but the log has already been written (so the commit was done for free.)

login_mode

The type of login that is supported. This property corresponds to the login_mode option.

login_procedure

The name of the stored procedure used to set compatibility options at startup. This property corresponds to the login_procedure option.

LoginTime

The date and time the connection was established. If the database has the time_zone option set, then the value is returned using the database's time zone.

LogWrite

The number of pages that have been written to the transaction log.

materialized_view_optimization

The value of the materialized_view_optimization option for the connection, which indicates whether materialized views are used during query optimization.

max_connections

The value of the max_connections option, which indicates the number of concurrent connections allowed to the database.

max_client_statements_cached

The value of the max_client_statements_cached option, which indicates the number of statements cached by the client.

max_cursor_count

The maximum number of cursors that a connection can use at once. This property corresponds to the max_cursor_count option.

max_hash_size

This property is deprecated.

max_plans_cached

The maximum number of execution plans to be stored in a cache. This property corresponds to the max_plans_cached option.

max_priority

The maximum priority level a connection can have. This property corresponds to the max_priority option for the connection.

max_query_tasks

The maximum number of requests that the database server can use to process a query. This property corresponds to the max_query_tasks option.

max_recursive_iterations

The maximum number of iterations a recursive common table expression can make. This property corresponds to the max_recursive_iterations option.

max_statement_count

The maximum number of prepared statements that a connection can use simultaneously. This property corresponds to max_statement_count option.

max_temp_space

The maximum amount of temporary file space available for a connection. This property corresponds to f the max_temp_space option for the connection.

MessageReceived

The string that was generated by the MESSAGE statement that caused the WAITFOR statement to be interrupted. Otherwise, an empty string is returned.

min_password_length

The minimum length for new passwords in the database. This property corresponds to min_password_length option.

min_role_admins

The minimum number of administrators required for a role. This property corresponds to the min_role_admins option.

Name

The name of the current connection. You can specify a connection name using the ConnectionName (CON) connection parameter.

NcharCharSet

The NCHAR character set used by the connection. This property has extensions that you can specify when querying the property value.

nearest_century

The value of the nearest_century option, which indicates how two-digit years are interpreted in string-to-date conversions.

NodeAddress

The node for the client in a client/server connection. When the client and server are both on the same computer, an empty string is returned.

non_keywords

The value of the non_keywords option, which is a list of keywords, if any, that are turned off so they can be used as identifiers.

NumLocalTempTables

The number of local temporary tables in use by the connection.

Number

The connection ID (a number) for the current connection.

odbc_describe_binary_as_varbinary

The value is Off if the SQL Anywhere ODBC driver describes both BINARY and VARBINARY columns as SQL_BINARY. The value is On if the ODBC driver describes BINARY and VARBINARY columns as SQL_VARBINARY. This property corresponds to the odbc_describe_binary_as_varbinary option.

odbc_distinguish_char_and_varchar

Whether CHAR columns are described as SQL_CHAR (On) or they are described as SQL_VARCHAR (OFF). This property corresponds to the odbc_distinguish_char_and_varchar option.

oem_string

The string stored in the header page of the database file. This property corresponds to the oem_string option.

on_charset_conversion_failure

The behavior when an error is encountered during character set conversion. This property corresponds to the on_charset_conversion_failure option.

on_tsql_error

The behavior when an error is encountered while executing a stored procedure or T-SQL batch. This property corresponds to the on_tsql_error option.

optimization_goal

How query processing is optimized. This property corresponds to the optimization_goal option.

optimization_level

The value of the optimization_level option, which is a value between 0 and 15. This number is used to control the level of effort made by the SQL Anywhere query optimizer to find an access plan for a SQL statement.

optimization_workload

The level of effort made by the SQL Anywhere query optimizer to find an access plan for a SQL statement. This property corresponds to the optimization_workload option for the connection.t

OSUser

The operating system user name associated with the client process. If the client process is impersonating another user (or the set ID bit is set on Unix), the impersonated user name is returned. An empty string is returned for version 10.0.1 and earlier clients, and for HTTP and TDS clients.

PacketSize

The packet size used by the connection, in bytes. The value is NA if the request that is currently executing is part of an event handler. This property corresponds to the CommBufferSize (CBSIZE) connection parameter.

PacketsReceived

The number of client/server communication packets received. This value is not updated for HTTP or HTTPS connections.

PacketsReceivedUncomp

The number of packets that would have been received during client/server communications if compression was disabled. (This value is the same as the value for PacketsReceived if compression is disabled.)

PacketsSent

The number of client/server communication packets sent. This value is not updated for HTTP or HTTPS connections.

PacketsSentUncomp

The number of packets that would have been sent during client/server communications if compression was disabled. (This value is the same as the value for PacketsSent if compression is disabled.)

parameterization_level

The value of the parameterization_level option for the connection, which indicates the statement parameterization behavior.

ParameterizationPrepareCount

The number of prepares for statements that have been automatically parameterized.

ParentConnection

The connection ID of the connection that created a temporary connection to perform a database operation (such as performing a backup or creating a database). For other types of connections, the value is NULL.

pinned_cursor_percent_of_cache

The value of the pinned_cursor_percent_of_cache option, which indicates the percentage of the cache that can be used for pinning cursors.

post_login_procedure

The name of the procedure whose result set contains messages that should be displayed by applications when a user connects .This property corresponds to the post_login_procedure option.

precision

The value of the precision option, which indicates the decimal and numeric precision setting.

prefetch

The value of the prefetch option. The value is Off if no prefetching is done. The value is Conditional if prefetching occurs unless the cursor type is SENSITIVE or the query includes a proxy table. The value is Always if prefetching is done even for SENSITIVE cursor types and cursors that involve a proxy table.

Prepares

The number of statement preparations performed for the connection.

PrepStmt

The number of prepared statements currently being maintained by the database server.

preserve_source_format

Whether the original source definition of procedures, triggers, views, and event handlers is saved in system tables (On) or not (Off). This property corresponds to the preserve_source_format option.

prevent_article_pkey_update

Whether updates are not allowed to the primary key columns of tables involved in publications (On) or not (Off). This property corresponds to the prevent_article_pkey_update option.

priority

The value of the priority option for the connection, which indicates the priority level of a connection.

Progress

Information about how long a query has been running. This property has extensions that you can specify when querying the property value.

progress_messages

The value of the progress_messages option.

query_mem_timeout

The value of the query_mem_timeout option.

QueryBypassed

The number of requests optimized by the optimizer bypass.

QueryBypassedCosted

The number of requests processed by the optimizer bypass using costing.

QueryBypassedHeuristic

The number of requests processed by the optimizer bypass using heuristics.

QueryBypassedOptimized

The number of requests initially processed by the optimizer bypass and subsequently fully optimized by the optimizer.

QueryCachedPlans

The number of query execution plans currently cached for the connection.

QueryCachePages

The number of cache pages used to cache execution plans.

QueryDescribedBypass

The number of describe requests processed by the optimizer bypass.

QueryDescribedOptimizer

The number of describe requests processed by the optimizer.

QueryHeapPages

The number of cache pages used for query processing (hash and sort operations).

QueryJHToJNLOptUsed

The number of times a hash join was converted to a nested loops join.

QueryLowMemoryStrategy

The number of times the server changed its execution plan during execution as a result of low memory conditions. The strategy can change because less memory is currently available than the optimizer estimated, or because the execution plan required more memory than the optimizer estimated.

QueryMemActiveCurr

The number of requests actively using query memory.

QueryMemGrantFailed

The total number of times a request waited for query memory, but failed to get it.

QueryMemGrantGranted

The number of pages currently granted to requests.

QueryMemGrantRequested

The total number of times any request attempted to acquire query memory.

QueryMemGrantWaited

The total number of times any request waited for query memory.

QueryMemGrantWaiting

The current number of requests waiting for query memory.

QueryOpened

The number of OPEN requests for execution.

QueryOptimized

The number of requests fully optimized.

QueryReused

The number of requests that have been reused from the plan cache.

QueryRowsFetched

The number of rows that have been read from base tables, either by a sequential scan or an index scan, for this connection.

QueryRowsMaterialized

The number of rows that are written to work tables during query processing.

quoted_identifier

Whether strings enclosed in double quotes are interpreted as identifiers (On), or if they are interpreted as literal strings (Off). This property corresponds to the quoted_identifier option.

read_past_deleted

Whether sequential scans at isolation levels 1 and 2 skip uncommitted deleted rows (On), or sequential scans block on uncommitted deleted rows at isolation levels 1 and 2 (Off). This property corresponds to the read_past_deleted option.

recovery_time

The maximum length of time, in minutes, that the database server will take to recover from system failure. This property corresponds to the recovery_time option.

RecursiveIterations

The number of iterations for recursive unions.

RecursiveIterationsHash

The number of times recursive hash join used a hash strategy.

RecursiveIterationsNested

The number of times recursive hash join used a nested loops strategy.

RecursiveJNLMisses

The number of index probe cache misses for recursive hash join.

RecursiveJNLProbes

The number of times recursive hash join attempted an index probe.

remote_idle_timeout

The time, in seconds, of inactivity that web service client procedures and functions will tolerate. This property corresponds to the remote_idle_timeout option.

replicate_all

For internal use only.

ReqCountActive

The number of requests processed, or NULL if the RequestTiming server property is set to Off.

ReqCountBlockContention

The number of times the connection waited for atomic access, or NULL if the -zt option was not specified.

ReqCountBlockIO

The number of times the connection waited for I/O to complete, or NULL if the -zt option was not specified.

ReqCountBlockLock

The number of times the connection waited for a lock, or NULL if the -zt option was not specified.

ReqCountUnscheduled

The number of times the connection waited for scheduling, or NULL if the -zt option was not specified.

ReqStatus

The status of the request. The value is Idle when the connection is not currently processing a request. The value is Unscheduled* when the connection has work to do and is waiting for an available database server worker. The value is BlockedIO* when the connection is blocked waiting for an I/O. The value is BlockedContention* when the connection is blocked waiting for access to shared database server data structures. The value is BlockedLock when the connection is blocked waiting for a locked object. The value is Executing when the connection is executing a request. The values marked with an asterisk (*) are only returned when logging of request timing information has been turned on for the database server using the -zt server option. If request timing information is not being logged (the default), the values are reported as Executing.

ReqTimeActive

The amount of time, in seconds, spent processing requests, or NULL if the -zt option was not specified.

ReqTimeBlockContention

The amount of time, in seconds, spent waiting for atomic access, or NULL if the RequestTiming server property is set to Off.

ReqTimeBlockIO

The amount of time, in seconds, spent waiting for I/O to complete, or NULL if the -zt option was not specified.

ReqTimeBlockLock

The amount of time, in seconds, spent waiting for a lock, or NULL if the -zt option was not specified.

ReqTimeUnscheduled

The amount of unscheduled time, or NULL if the -zt option was not specified.

ReqType

The type of the last request. If a connection has been cached by connection pooling, its ReqType value is CONNECT_POOL_CACHE.

request_timeout

The value of the request_timeout option, which indicates the maximum time a single request can run.

RequestsReceived

The number of client/server communication requests or round trips. It is different from PacketsReceived in that multi-packet requests count as one request, and liveness packets are not included.

reserved_connections

The number of connections that are reserved for standard connections. This property corresponds to the reserved_connections option.

reserved_keywords

The value of the reserved_keywords option, which specifies a list of non-default reserved keywords that are enabled for the database.

return_date_time_as_string

Whether DATE, TIME, and TIMESTAMP values are returned to applications as a string (On), or they are returned as a DATE, TIME, or TIMESTAMP data type (Off). This property corresponds to the return_date_time_as_string option.

Rlbk

The number of rollback requests that have been handled.

rollback_on_deadlock

Whether transaction are automatically rolled back if it encounters a deadlock (On) or not (Off). This property corresponds to the rollback_on_deadlock option.

RollbackLogPages

The number of pages in the rollback log.

row_counts

Whether the row count is always accurate (On), or the row count is usually an estimate (Off). This property corresponds to the row_counts option.

scale

The decimal and numeric scale for the connection. This property corresponds to the scale option.

secure_feature_key

This property is deprecated. The value of the secure_feature_key option, which stores the key that is used to enable and disable features for a database server. Selecting the value of this property always returns an empty string.

ServerNodeAddress

The node for the server in a client/server connection. When the client and server are both on the same computer, an empty string is returned. The value is NA if the request that is currently executing is part of an event handler.

ServerPort

The database server's TCP/IP port number or 0.

SessionCreateTime

The time the HTTP session was created. If the database has the time_zone option set, then the value is returned using the database's time zone.

SessionID

The session ID for the connection if it exists, otherwise, an empty string.

SessionLastTime

The time of the last request for the HTTP session. If the database has the time_zone option set, then the value is returned using the database's time zone.

SessionTimeout

The time, in minutes, the HTTP session persists during inactivity.

SnapshotCount

The number of snapshots associated with the connection.

sort_collation

The value of the sort_collation option. The value is Internal if the ORDER BY clause remains unchanged; otherwise, the value is the collation name or the collation ID.

SortMergePasses

The number of merge passes used during sorting.

SortRowsMaterialized

The number of rows written to sort work tables.

SortRunsWritten

The number of sorted runs written during sorting.

SortSortedRuns

The number of sorted runs created during run formation.

SortWorkTables

The number of work tables created for sorting.

sql_flagger_error_level

The value of the sql_flagger_error_level option, which controls the response to any SQL that is not part of the specified standard. This property corresponds to the sql_flagger_error_level option.

sql_flagger_warning_level

The value of the sql_flagger_warning_level. This property corresponds to the sql_flagger_warning_level option.

st_geometry_asbinary_format

How spatial values are converted from a geometry to a binary format. This property corresponds to the st_geometry_asbinary_format option.

st_geometry_astext_format

How spatial values are converted from a geometry to text. This property corresponds to the st_geometry_astext_format option.

st_geometry_asxml_format

How spatial values are converted from a geometry to XML. This property corresponds to the st_geometry_asxml_format option.

st_geometry_describe_type

How spatial values are described. This property corresponds to the st_geometry_describe_type option.

st_geometry_interpolation

The interpolation setting for ST_CircularString geometries. This property corresponds to st_geometry_interpolation option.

st_geometry_on_invalid

The behavior when a geometry fails surface validation. This property corresponds to the st_geometry_on_invalid option.

StatementDescribes

The total number of statements processed by DESCRIBE requests.

StatementPostAnnotates

The number of statements processed by the semantic query transformation phase.

StatementPostAnnotatesSimple

The number of statements processed by the semantic query transformation phase, but that skipped some of the semantic transformations.

StatementPostAnnotatesSkipped

The number of statements that have completely skipped the semantic query transformation phase.

string_rtruncation

Whether an error is raised when a string is truncated (On), or no error is not raised (Off) This property corresponds to the string_rtruncation option.

subsume_row_locks

Whether the database server acquires individual row locks for a table (On), or not (Off). This property corresponds to the subsume_row_locks option.

suppress_tds_debugging

Whether TDS debugging information appears in the database server messages window (Off), or the debugging information does not appear in the database server messages window (On). This property corresponds to the suppress_tds_debugging option.

synchronize_mirror_on_commit

Whether the database mirror server is synchronized on commit (On) or not (Off). This property corresponds to the synchronize_mirror_on_commit option.

tds_empty_string_is_null

Whether empty strings are returned as NULL for TDS connections (On), or if a string containing one blank character is returned for TDS connections (Off). This property corresponds to the tds_empty_string_is_null option.

temp_space_limit_check

Whether the database server checks the amount of temporary space available for a connection (On), or the database server does not check the amount of space available for a connection (Off). This property corresponds to the temp_space_limit_check option.

TempFilePages

The number of temporary file pages used by the connection.

TempTablePages

The number of pages in the temporary file used for temporary tables.

time_format

The string format used for times retrieved from the database. This property corresponds to the time_format option.

time_zone

The time zone that the database uses for time zone calculations. This property corresponds to the time_zone option.

time_zone_adjustment

The number of minutes that must be added to the Coordinated Universal Time (UTC) to display time local to the connection. This property corresponds to the time_zone_adjustment option.

timestamp_format

The format for timestamps that are retrieved from the database. This property corresponds to the timestamp_format option.

timestamp_with_time_zone_format

The format for TIMESTAMP WITH TIME ZONE values retrieved from the database. This property corresponds to the timestamp_with_time_zone_format option.

TimeZoneAdjustment

The number of minutes that must be added to the Coordinated Universal Time (UTC) to display time local to the connection.

TransactionStartTime

The value is a string containing the time the database was first modified after a COMMIT or ROLLBACK, or an empty string if no modifications have been made to the database since the last COMMIT or ROLLBACK. If the database has the time_zone option set, then the value is returned using the database's time zone.

truncate_timestamp_values

Whether the number of decimal places used in the TIMESTAMP values is limited (On) or not (Off). This property corresponds to the truncate_timestamp_values option.

trusted_certificates_file

The file that contains the list of trusted Certificate Authority certificates when the database server acts as a client to an LDAP server. This property corresponds to the trusted_certificates_file option.

tsql_outer_joins

Whether Transact-SQL outer joins can be used in DML statement (On) or not (Off). This property corresponds to the value of the tsql_outer_joins option.

tsql_variables

Whether you can use the @ sign instead of the colon as a prefix for host variable names in Embedded SQL (On) or not (Off). This property corresponds to the value of the tsql_variables option.

UncommitOp

The number of uncommitted operations.

updatable_statement_isolation

The isolation level (0, 1, 2, or 3) used by updatable statements when the isolation_level option is set to Readonly-statement-snapshot. This property corresponds to the updatable_statement_isolation option.

update_statistics

Whether the connection can send query feedback to the statistics governor (On) or the statistics governor does not receive query feedback from the current connection (Off). This property corresponds to the update_statistics option.

upgrade_database_capability

This property is reserved for system use. Do not change the setting of this option.

user_estimates

The value that controls whether selectivity estimates in query predicates are respected or ignored by the query optimizer. This property corresponds to the user_estimates option.:

UserAppInfo

The string specified by the AppInfo connection parameter in a connection string.

UserDefinedCounterRate01

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRate02

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRate03

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRate04

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRate05

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRaw01

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRaw02

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRaw03

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRaw04

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserDefinedCounterRaw05

The current value of the user-defined performance counter. The semantics of this property are defined by the client application.

UserID

The user ID for the connection.

UtilCmdsPermitted

Whether SQL statements such as CREATE DATABASE, DROP DATABASE, and RESTORE DATABASE are permitted for the connection or not. The value is an empty string if the specified connection ID is not for the current connection.

uuid_has_hyphens

The format of unique identifier values when they are converted to strings. When the option is set to On, the resulting strings contain four hyphens. This property corresponds to the uuid_has_hyphens option.

verify_password_function

The name of the function used for password verification if one has been specified. This property corresponds to the verify_password_function.

wait_for_commit

Whether the database does not check foreign key integrity until the next COMMIT statement (On), or all foreign keys that are not created with the CHECK ON COMMIT clause are checked as they are inserted, updated or deleted (Off). This property corresponds to the wait_for_commit option.

WaitStartTime

The time at which the connection started waiting (or an empty string if the connection is not waiting). If the database has the time_zone option set, then the value is returned using the database's time zone.

WaitType

The reason for the wait, if it is available. The value is lock when the connection is waiting on a lock The value is waitfor when the connection is executing a waitfor statement. The value is an empty-string when the connection is not waiting, or when the reason for the wait is not available.

webservice_namespace_host

The hostname to be used as the XML namespace within generated WSDL documents if one has been specified. This property corresponds to the webservice_namespace_host option,

webservice_sessionid_name

The session identifier name that is used by the web server to determine whether session management is being used. This property corresponds to the webservice_sessionid_name option.