Database properties 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.
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' ); |
Use the sa_eng_properties system procedure:
CALL sa_eng_properties; |
Property name | Description | ||
---|---|---|---|
ActiveReq | Returns the number of server workers that are currently handling client-side requests. | ||
ApproximateCPUTime | Returns an estimate of the amount of CPU time accumulated by the database server, 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. This property is supported on Windows and Linux. | ||
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 arguments that were 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. |
||
Commit | Returns the number of Commit requests that have been handled. | ||
CompactPlatformVer | Returns a condensed version of the PlatformVer property. | ||
CompanyName | Returns the name of the company owning this software. | ||
ConnectedTime |
Returns the total length of time, in seconds, that all connections have been connected to the database server. The value is updated only when a request completes for a connection or when a connection disconnects. As a result, the value can lag behind for connections that are idle or busy executing for a long time in the database server. The value includes time accrued by any connection, including database events and background server connections (such as the database cleaner) |
||
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 Database server action logging. | ||
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 Database server configuration of the multiprogramming level. | ||
Cursor | Returns the number of declared cursors that are currently being maintained by the database server. | ||
CursorOpen | Returns the number of open cursors that are currently being maintained by the database server. | ||
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 Advanced: 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:
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:
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):
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:
|
||
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:
|
||
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-certified 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 on 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. | ||
LicenseKey | For internal use only. | ||
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 Database server configuration of the 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 |
||
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 Database server configuration of the 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 and ServerName server property. 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:
For more information about supported platforms, see 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. | ||
PrepStmt | Returns the number of prepared statements currently being maintained by the database server. | ||
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. 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 Performance Monitor. |
||
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. 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 Performance Monitor. |
||
ProcessID |
Returns the process ID of the database server process. |
||
ProcessorArchitecture |
Returns a string that identifies the processor type that the current software was built for. Values include:
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 user ID 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 requests 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 times the server had to block while sending a communication packet. Typically, blocking only occurs if the database server is sending data faster than the client or network can receive it. It does not indicate an error condition. | ||
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. | ||
ReqCountActive | Returns the number of times the server has been entered to allow it to handle a new request or continue processing an existing request. | ||
ReqCountBlockContention | Returns the number of times that any connection has blocked due to contention for an internal server resource. | ||
ReqCountBlockIO | Returns the number of times that any connection has blocked while waiting for an IO request to complete. | ||
ReqCountBlockLock | Returns the number of times that any connection has blocked while waiting for a row lock held by another connection. | ||
ReqCountUnscheduled | Returns the number of times that any connection has blocked while waiting for a server thread to process it. | ||
ReqTimeActive | Returns the total amount of time that the server has spent directly servicing requests. | ||
ReqTimeBlockContention | Returns the total amount of time that any connection has blocked due to contention for an internal server resource. | ||
ReqTimeBlockIO | Returns the total amount of time that any connection has blocked while waiting for an IO request to complete. | ||
ReqTimeBlockLock | Returns the total amount of time that any connection has blocked while waiting for a row lock held by another connection. | ||
ReqTimeUnscheduled | Returns the total amount of time that any connection has blocked while waiting for a server thread to process it. | ||
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. | ||
Rlbk | The number of rollback requests that have been handled. | ||
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:
If you have a separate license for any of the following features, then the appropriate string(s) are added to the license string that is returned:
|
||
ServerName | Returns the real server name (never an alternate server name). You can use this value to determine which of the operational servers is currently acting as primary in a database mirroring configuration. See Database mirroring and Name server property. | ||
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:
|
||
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 Database server configuration of the 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. | ||
UserDefinedCounterRate01 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time. For more information, see User-defined properties. |
||
UserDefinedCounterRate02 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time. For more information, see User-defined properties. |
||
UserDefinedCounterRate03 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time. For more information, see User-defined properties. |
||
UserDefinedCounterRate04 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time. For more information, see User-defined properties. |
||
UserDefinedCounterRate05 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time. For more information, see User-defined properties. |
||
UserDefinedCounterRaw01 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter. For more information, see User-defined properties. |
||
UserDefinedCounterRaw02 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter. For more information, see User-defined properties. |
||
UserDefinedCounterRaw03 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter. For more information, see User-defined properties. |
||
UserDefinedCounterRaw04 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter. For more information, see User-defined properties. |
||
UserDefinedCounterRaw05 |
Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter. For more information, see User-defined properties. |
||
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.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |