Show Limits
Summary
The SHOW LIMITS command returns a result set summarizing the system usage limits imposed by Connect.
Syntax
show limits; |
Parameters
None
Details
The SHOW LIMITS result set includes the following columns.
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
| name | string | The system limit name. Xactly may add or modify the set of limits over time as new releases of Connect are deployed. |
| value | string | System limit default values. These values are set by Xactly and cannot be modified by end users. |
The following table lists the system limits and their definitions. Xactly reserves the right to modify the list of parameters and their values.
|
Limit Name
|
Description
|
|---|---|
|
maxConcurrentQueries |
Maximum number of queries that can be concurrently executing for this server node in the Xactly clustered environment. |
|
maxConcurrentQueriesPerBusiness |
Maximum number of concurrent queries per business across the Xactly clustered environment. |
|
maxDropTimeInMinutes |
Number of minutes Connect will wait for a “drop” command to finish. |
|
maxExternalRows |
How many rows we allow to be read from an external data source in a single query. For example, Salesforce.com. |
|
maxImmediateResultRows |
The number of rows Connect will allow to be returned from the “execute immediate” XDBC REST entry point. |
|
maxJoinRows |
Maximum number of rows a single table in a join will be allowed to cache in memory. |
|
maxJoins |
The maximum number of join nodes allowed in a single SQL statement. |
|
maxQueryTimeInMinutes |
Maximum query time in minutes. |
|
maxResultRows |
Maximum result set rows that can be create using any command. |
|
maxShowRows |
Maximum number of rows allowed in a “show” command returned result set. |
|
maxSystemQueryTimeInMinutes |
Maximum time that a system query is allowed to run. Running a pipeline from a Connect schedule or an Incent Process Group are examples of system queries (as opposed to running ad-hoc xSQL queries from an ODBC client). |
Please contact Xactly’s Tech Support team if your queries hit any of these limits.
Examples
show limits;
Related Commands
N/A