Database server properties

The following table lists properties that apply across the database server as a whole.

You can use the PROPERTY system function to retrieve the value for an individual property, or you can use the sa_eng_properties system procedure to retrieve the values of all database server properties. Property names are case insensitive.

Examples

To retrieve the value of a database server property

Use the PROPERTY system function. For example, the following statement returns the number of cache pages used for global server data structures:
SELECT PROPERTY ( 'MainHeapPages' );

To retrieve the values of all database server properties

Use the sa_eng_properties system procedure:
CALL sa_eng_properties;

Descriptions

Property name Description

ActiveReq Returns the number of server workers that are currently handling client-side requests.

AutoMultiProgrammingLevel Returns a value indicating whether the database server is automatically adjusting its multiprogramming level. See -gna dbsrv12 server option.

AutoMultiProgrammingLevelStatistics Returns a value indicating whether messages about automatic adjustments to the database server's multiprogramming level are displayed in the database server message log. See -gns dbsrv12 server option.

AvailIO Returns the current number of available I/O control blocks.

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

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

BuildProduction Returns Yes if the database server is compiled for production use or returns No if the database server is a debug build.

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

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

BytesReceivedUncomp Returns 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 Returns the number of bytes sent during client/server communications. This value is updated for HTTP and HTTPS connections.

BytesSentUncomp Returns 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.)

CacheAllocated Returns the number of cache pages that have been allocated for server data structures.

CacheFile Returns the number of cache pages used to hold data from database files.

CacheFileDirty Returns the number of cache pages that are dirty (needing a write).

CacheFree Returns the number of cache pages not being used.

CacheHits Returns the number of database page lookups.

CachePanics Returns the number of times the cache manager has failed to find a page to allocate.

CachePinned Returns the number of pinned cache pages.

CacheRead Returns the number of cache reads.

CacheReplacements Returns the number of pages in the cache that have been replaced.

CacheScavenges Returns the number of times the cache manager has scavenged for a page to allocate.

CacheScavengeVisited Returns the number of pages visited while scavenging for a page to allocate.

CacheSizingStatistics Returns Yes if the server is displaying cache sizing statistics when the cache is resized, otherwise, returns No. See -cs dbeng12/dbsrv12 server option.

CarverHeapPages Returns the number of heap pages used for short-term purposes such as query optimization.

CharSet Returns the CHAR character set in use by the database server.

ClientStmtCacheHits Returns the number of prepares that were not required because of the client statement cache. This is the number of additional prepares that would be required if client statement caching was disabled. See max_client_statements_cached option.

ClientStmtCacheMisses Returns the number of statements in the client statement cache that were prepared again. This 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. See max_client_statements_cached option.

CollectStatistics Returns Yes or No to indicate whether the database server is collecting performance statistics. See -k dbeng12/dbsrv12 server option.

CommandLine

Returns the command line that was used to start the database server.

If the encryption key for a database was specified using the -ek option, the key is replaced with a constant string of asterisks in the value returned by this property.

CompactPlatformVer Returns a condensed version of the PlatformVer property.

CompanyName Returns the name of the company owning this software.

ConnsDisabled Returns Yes or No to indicate the current setting of the server option to disable new connections. See sa_server_option system procedure.

ConsoleLogFile Returns the name of the file where database server messages are logged if the -o option was specified, otherwise returns an empty string. See -o dbeng12/dbsrv12 server option and Logging database server actions.

ConsoleLogMaxSize Returns the maximum size in bytes of the file used to log database server messages. See -os dbeng12/dbsrv12 server option.

CurrentCacheSize Returns the current cache size, in kilobytes.

CurrentMultiProgrammingLevel Returns the current number of tasks that the database server can process concurrently. See Configuring the database server's multiprogramming level.

DebuggingInformation Returns Yes if the server is displaying diagnostic messages for troubleshooting, and No otherwise. See -z dbeng12/dbsrv12 server option.

DefaultCollation Returns the collation that would be used for new databases if none is explicitly specified.

DefaultNcharCollation Returns the name of the default NCHAR collation on the server computer (UCA if ICU is installed, and UTF8BIN otherwise).

DiskRead Returns the number of disk reads.

DiskReadHintScatterLimit Returns the imposed limit on the size (in bytes) of a scatter read hint.

DiskRetryRead Returns the number of disk read retries.

DiskRetryReadScatter Returns the number of disk read retries for scattered reads.

DiskRetryWrite Returns the number of disk write retries.

EventTypeDesc Returns the system event type description associated with a given event type ID.

EventTypeName Returns the system event type name associated with a given event type ID.

ExchangeTasks Returns the number of tasks currently being used for parallel execution of queries.

ExchangeTasksCompleted Returns the total number of internal tasks that have been used for intra-query parallelism since the database server started. See Parallelism during query execution.

FipsMode Returns Yes if the -fips option was specified when the database server was started, and No otherwise.

FirstOption Returns the number that represents the first connection property that corresponds to a database option.

FreeBuffers Returns the number of available network buffers.

FunctionMaxParms

Returns the maximum number of parameters that can be specified by a function. The function is identified by the value specified by the function-number, which is a positive integer. For example:

SELECT PROPERTY ( 'FunctionMaxParms', function-number );

Note that the function-number is subject to change between releases.

FunctionMinParms

Returns the minimum number of parameters that must be specified by a function. The function is identified by the value specified by the function-number, which is a positive integer. For example:

SELECT PROPERTY ( 'FunctionMaxParms', function-number );

Note that the function-number is subject to change between releases.

FunctionName

Returns the name of the function identified by the value specified by the function-number (which is a positive integer):

SELECT PROPERTY ( 'FunctionName', function-number );

Note that the function-number is subject to change between releases.

HeapsCarver Returns the number of heaps used for short-term purposes such as query optimization.

HeapsLocked Returns number of relocatable heaps currently locked in the cache.

HeapsQuery Returns the number of heaps used for query processing (hash and sort operations).

HeapsRelocatable Returns the number of relocatable heaps.

HttpAddresses

Returns a semicolon delimited list of the TCP/IP addresses the server is listening to for HTTP connections. For example:

(::1):80;127.0.0.1:80

HttpNumActiveReq Returns the number of HTTP connections that are actively processing an HTTP request. An HTTP connection that has sent its response is not included.

HttpNumConnections Returns the number of HTTP connections that are currently open within the database server. They may be actively processing a request or waiting in a queue of long lived (keep-alive) connections.

HttpNumSessions Returns the number of active and dormant HTTP sessions within the database server.

HttpPorts Returns the HTTP port numbers for the web server as a comma delimited list.

HttpsAddresses

Returns a semicolon delimited list of the TCP/IP addresses the server is listening to for HTTPS connections. For example:

(::1):443;127.0.0.1:443

HttpsNumActiveReq Returns the number of secure HTTPS connections that are actively processing an HTTPS request. An HTTPS connection that has sent its response is not included.

HttpsNumConnections Returns the number of HTTPS connections that are currently open within the database server. They may be actively processing a request or waiting in a queue of long lived (keep-alive) connections.

HttpsPorts Returns the HTTPS port numbers for the web server as a comma delimited list.

IdleTimeout Returns the default idle timeout. See -ti dbeng12/dbsrv12 server option.

IPAddressMonitorPeriod Returns the time in seconds that a database server checks for new IP addresses. See -xm dbeng12/dbsrv12 server option.

IsEccAvailable Returns Yes if the ECC DLL is installed, and No otherwise.

IsFipsAvailable Returns Yes if the FIPS DLL is installed, and No otherwise.

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

IsNetworkServer Returns Yes if connected to a network database server, and No if connected to a personal database server.

IsPortableDevice

Returns Yes if the database server is running on a laptop, notebook, or other portable device, and No otherwise. Yes is always returned on Windows Mobile. VMWare is not taken into account, so a database server running in a VM that is running on a laptop returns No.

On Windows if it is not possible to determine whether the device is portable, this property returns NULL.

This property always returns NULL on Unix.

IsRsaAvailable Returns Yes if the RSA DLL is installed, and No otherwise.

IsRuntimeServer Returns No for all versions of the database server.

IsService Returns Yes if the database server is running as a service, and No otherwise.

Language Returns the locale language for the server.

LastConnectionProperty Returns the number that represents the last connection property.

LastDatabaseProperty Returns the number that represents the last database property.

LastOption Returns the number that represents the last connection property that corresponds to a database option.

LastServerProperty Returns the number that represents the last server property.

LegalCopyright Returns the copyright string for the software.

LegalTrademarks Returns trademark information for the software.

LicenseCount Returns the number of licensed seats or processors.

LicensedCompany Returns the name of the licensed company.

LicensedUser Returns the name of the licensed user.

LicenseType Returns the license type. Can be networked seat (per-seat) or CPU-based.

LivenessTimeout Returns the client liveness timeout default. See -tl dbeng12/dbsrv12 server option.

LockedCursorPages Returns the number of pages used to keep cursor heaps pinned in memory.

LockedHeapPages Returns the number of heap pages locked in the cache.

MachineName Returns the name of the computer running a database server. Typically, this is the computer's host name.

MainHeapBytes Returns the number of bytes used for global server data structures.

MainHeapPages Returns the number of pages used for global server data structures.

MapPhysicalMemoryEng Returns the number of database page address space windows mapped to physical memory in the cache using Address Windowing Extensions.

MaxCacheSize Returns the maximum cache size allowed, in kilobytes.

MaxConnections

Returns the maximum number of concurrent connections the server allows. For the personal server, this value defaults to 10. For the network server, this value defaults to about 32000. This value can be lowered using the -gm server option. See -gm dbeng12/dbsrv12 server option.

Computer resources typically limit the number of connections to a network server to a lower value than the default.

MaxEventType Returns the maximum valid event type ID.

MaxMessage This property is deprecated. Returns the current maximum line number that can be retrieved from the database server messages window. This represents the most recent message displayed in the database server messages window.

MaxMultiProgrammingLevel Returns the maximum number of tasks that the database server can process concurrently. See Configuring the database server's multiprogramming level.

MaxRemoteCapability Returns the maximum valid capability ID.

Message

This property is deprecated. Returns a line from the database server messages window, prefixed by the date and time the message appeared. The second parameter specifies the line number.

The value returned by PROPERTY( "message" ) is the first line of output that was written to the database server messages window. Calling PROPERTY( "message", n ) returns the n-th line of server output (with zero being the first line). The buffer is finite, so as messages are generated, the first lines are dropped and may no longer be available in memory. In this case, NULL is returned.

MessageCategoryLimit Returns the minimum number of messages of each severity and category that can be retrieved using the sa_server_messages system procedure. The default value is 400. See sa_server_messages system procedure.

MessageText This property is deprecated. Returns the text associated with the specified line number in the database server messages window, without a date and time prefix. The second parameter specifies the line number.

MessageTime This property is deprecated. Returns the date and time associated with the specified line number in the database server messages window. The second parameter specifies the line number.

MessageWindowSize This property is deprecated. Returns the maximum number of lines that can be retrieved from the database server messages window.

MinCacheSize Returns the minimum cache size allowed, in kilobytes.

MinMultiProgrammingLevel Returns the minimum number of tasks that the server can process concurrently. See Configuring the database server's multiprogramming level.

MultiPacketsReceived Returns the number of multi-packet requests received during client/server communications.

MultiPacketsSent Returns the number of multi-packet responses sent during client/server communications.

MultiPageAllocs Returns the number of multi-page cache allocations.

MultiProgrammingLevel Returns the maximum number of concurrent tasks the server can process. Requests are queued if there are more concurrent tasks than this value. This can be changed with the -gn server option. See -gn dbsrv12 server option.

Name

Returns the alternate name of the server used to connect to the database if one was specified, otherwise, returns the real server name. See -sn dbsrv12 database option.

If the client is connected to a copy node and specified NodeType=COPY in the connection string, then the value of this property may be different than the database server name specified in the client connection string by the ServerName connection parameter. See NodeType (NODE) connection parameter.

NativeProcessorArchitecture

Returns a string that identifies the native processor type on which the software is running for platforms where a processor can be emulated (such as X86 on Win64). In all other cases, it returns the same value as the ProcessorArchitecture property. See ProcessorArchitecture server property.

The value X86 can be returned for X86, IA86 or X86_64. This property does not return a value that indicates whether the operating system is 32-bit or 64-bit.

Values can include:

32-bit Windows, except Windows Mobile, - X86
Windows Mobile - ARM
64-bit Windows - X86_64
Solaris - SPARC or X86_64
AIX - PPC
MAC OS - X86 or X86_64
HP - IA64
Linux - X86 or X86_64

For more information on supported platforms, see [external link] http://www.sybase.com/detail?id=1002288.

NumLogicalProcessors Returns the number of logical processors (including cores and hyperthreads) enabled on the server computer.

NumLogicalProcessorsUsed Returns the number of logical processors the database server will use. On Windows, use the -gtc option to change the number of logical processors used. See -gtc dbeng12/dbsrv12 server option.

NumPhysicalProcessors Returns the number of physical processors enabled on the server computer. This value is NumLogicalProcessors divided by the number of cores or hyperthreads per physical processor. On some non-Windows platforms, cores or hyperthreads may be counted as physical processors.

NumPhysicalProcessorsUsed Returns the number of physical processors the database server will use. The personal server is limited to one processor on some platforms. On Windows, you can use the -gt option to change the number of physical processors used by the network database server. See -gt dbeng12/dbsrv12 server option.

ObjectType Returns the type of database object. This value is used by the SYSOBJECT system view. See SYSOBJECT system view.

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

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

PacketsReceivedUncomp Returns 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 Returns the number of client/server communication packets sent. This value is not updated for HTTP or HTTPS connections.

PacketsSentUncomp Returns 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.)

PageSize Returns the size of the database server cache pages. This can be set using the -gp option, otherwise, it is the maximum database page size of the databases specified on the command line.

PeakCacheSize Returns the largest value the cache has reached in the current session, in kilobytes.

Platform Returns the operating system on which the software is running. For example, if you are running on Windows XP, this property returns WindowsXP.

PlatformVer Returns the operating system on which the software is running, including build numbers, service packs, and so on.

ProcessCPU

Returns CPU usage for the database server process. Values are in seconds. This property is supported on Windows and Unix. This property is not supported on Windows Mobile.

The value returned for this property is cumulative since the database server was started. The value will not match the instantaneous value returned by applications such as the Windows Task Manager or the Windows Performance Monitor.

ProcessCPUSystem

Returns system CPU usage for the database server process CPU. This is the amount of CPU time that the database server spent inside the operating system kernel. Values are in seconds. This property is supported on Windows and Unix. This property is not supported on Windows Mobile.

ProcessCPUUser

Returns user CPU usage for the database server process. Values are in seconds. This excludes the amount of CPU time that the database server spent inside the operating system kernel. This property is supported on Windows and Unix. This property is not supported on Windows Mobile.

ProcessorArchitecture

Returns a string that identifies the processor type that the current software was built for. Values include:

32-bit Windows (except Windows Mobile) - X86
64-bit Windows - X86_64
Windows Mobile - ARM
Solaris - SPARC or X86_64
AIX - PPC
MAC OS - X86
HP - IA64
Linux - X86 or X86_64

For x86 and x64 platforms, this property returns X86 for 32-bit database servers and X86_64 for 64-bit database servers.

For more information, see NativeProcessorArchitecture server property.

ProductName Returns the name of the software.

ProductVersion Returns the version of the software being run.

ProfileFilterConn Returns the ID of the connection being monitored if procedure profiling for a specific connection is turned on. Otherwise, returns an empty string. You control procedure profiling by user with the sa_server_option procedure. See sa_server_option system procedure.

ProfileFilterUser Returns the name of the user being monitored if procedure profiling for a specific user is turned on. Otherwise, returns an empty string. You control procedure profiling by user with the sa_server_option procedure. See sa_server_option system procedure.

QueryHeapPages Returns the number of cache pages used for query processing (hash and sort operations).

QueryMemActiveCurr Returns the number of requests actively using query memory.

QueryMemActiveEst Returns the database server's estimate of the steady state average of the number of requests actively using query memory.

QueryMemActiveMax Returns the maximum number of requests that are actively allowed to use query memory.

QueryMemExtraAvail Returns the amount of memory available to grant beyond the base memory-intensive grant.

QueryMemGrantBase Returns the minimum amount of memory granted to all requests.

QueryMemGrantBaseMI Returns the minimum amount of memory granted to memory-intensive requests.

QueryMemGrantExtra Returns the number of query memory pages that can be distributed among active memory intensive beyond QueryMemGrantBaseMI.

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

QueryMemGrantGranted Returns the number of pages currently granted to requests.

QueryMemGrantRequested Returns the total number of times any request attempted to acquire query memory.

QueryMemGrantWaited Returns the total number of times any request waited for query memory.

QueryMemGrantWaiting Returns the current number of requests waiting for query memory.

QueryMemPages Returns the amount of memory that is available for query execution algorithms, expressed as a number of pages.

QueryMemPercentOfCache Returns the amount of memory that is available for query execution algorithms, expressed as a percent of maximum cache size.

QuittingTime Returns the shutdown time for the server. If none is specified, the value is none.

RememberLastPlan Returns Yes if the server is recording the last query optimization plan returned by the optimizer. See -zp dbeng12/dbsrv12 server option.

RememberLastStatement Returns Yes if the server is recording the last statement prepared by each connection, and No otherwise. See -zl dbeng12/dbsrv12 server option.

RemoteCapability Returns the remote capability name associated with a given capability ID.

RemoteputWait Returns the number of remote put waits.

Req Returns the number of times the server has been entered to allow it to handle a new request or continue processing an existing request.

RequestFilterConn Returns the ID of the connection that logging information is being filtered for, otherwise, returns -1.

RequestFilterDB Returns the ID of the database that logging information is being filtered for, otherwise, returns -1.

RequestLogFile Returns the name of the request logging file. An empty string is returned if there is no request logging. See sa_server_option system procedure.

RequestLogging Returns one of SQL, PLAN, HOSTVARS, PROCEDURES, TRIGGERS, OTHER, BLOCKS, REPLACE, ALL, or NONE, indicating the current setting for request logging. See sa_server_option system procedure.

RequestLogMaxSize Returns the maximum size of the request log file. See -zs dbeng12/dbsrv12 server option.

RequestLogNumFiles

Returns the number of request log files being kept. See sa_server_option system procedure.

RequestsReceived Returns 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.

RequestTiming Returns Yes if request timing is turned on, and No otherwise. Request timing is turned on using the -zt database server option. See -zt dbeng12/dbsrv12 server option.

SendFail Returns the number of times that the underlying communications protocols have failed to send a packet.

ServerEdition

Returns a space separated list of words describing the database server type. Values include:

Evaluation
Developer
Web
Evaluation
Standard
Advanced
Workgroup
OEM
Authenticated

If you have a separate licence for any of the following features, then the appropriate string(s) are added to the license string that is returned:

HighAvailability See SQL Anywhere high availability option.
InMemory See SQL Anywhere in-memory mode option.
ECC See SQL Anywhere security option.
FIPS See SQL Anywhere security option.

ServerName Returns the name of the server for the current connection. You can use this value to determine which of the operational servers is currently acting as primary in a database mirroring configuration. See Introduction to database mirroring.

StartDBPermission Returns the setting of the -gd server option, which can be one of DBA, all, or none. See -gd dbeng12/dbsrv12 server option.

StartTime Returns the date/time that the server started.

StreamsUsed Returns the number of database server streams in use.

TcpIpAddresses

Returns a semicolon delimited list of the TCP/IP addresses the server is listening to for Command Sequence and TDS connections. For example:

(::1):2638;127.0.0.1:2638

TempDir Returns the directory in which temporary files are stored by the server.

ThreadDeadlocksAvoided

Returns the number of times a thread deadlock error was detected but not reported to client applications. When the database server starts, the value of this property is 0.

To avoid returning thread deadlock errors, the database server dynamically increases the multiprogramming level. If the multiprogramming level cannot be increased, a thread deadlock error is returned to the client application and the ThreadDeadlocksReported property is incremented. The ThreadDeadlocksAvoided property is always 0 on the personal server because dynamic tuning of the multiprogramming level is disabled by default.

For more information, see Configuring the database server's multiprogramming level.

ThreadDeadlocksReported Returns the number of times a thread deadlock error was reported to client applications. When the database server starts, the value of this property is 0.

TimeZoneAdjustment Returns the number of minutes that must be added to the Coordinated Universal Time (UTC) to display time local to the server.

TotalBuffers Returns the total number of network buffers.

UniqueClientAddresses Returns the number of unique client network addresses connected to a network server.

UnschReq Returns the number of requests that are currently queued up waiting for an available server worker.

WebClientLogFile Returns the name of the web service client log file. See -zoc dbeng12/dbsrv12 server option.

WebClientLogging Returns a value that indicates whether web service client information is being logged to a file. See -zoc dbeng12/dbsrv12 server option.

Discuss this page in DocCommentXchange.