PooledConnections: SQL Server Pooled Connections |
Catalog: Database
Schema: Invantive
Label: Pooled Connections
This is a read-only view. The SQL Server API may not support changing the data or the Invantive SQL driver for SQL Server does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the SQL Server API.
View Columns
The columns of the view PooledConnections are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CONNECTION_TIMEOUT_SEC |
int32 |
Connection Time-out (sec) |
☑ |
|
COUNT_TIMES_USED |
int32 |
Number of Times Used |
|
|
CREATED_UTC |
datetime |
Date Created |
|
|
CURRENT_CONTEXT_DESCRIPTION |
string(240) |
Current Context Description |
|
|
CURRENT_CONTEXT_NATURAL_KEY |
string(240) |
Current Context Natural Key |
|
|
CURRENT_CONTEXT_USER_LOG_ON_CODE |
string(240) |
Current Context User Log On Code |
|
|
DATABASE |
string(240) |
Database |
☐ |
|
DURATION_USED_MS |
int32 |
Duration Used (ms) |
|
|
ID |
int32 |
ID |
|
|
IS_FREE |
boolean |
Is Free |
☑ |
|
LAST_USE_DURATION_MS |
int32 |
Last Use Duration (ms) |
|
|
LAST_USE_END_UTC |
datetime |
Last Use End |
|
|
LAST_USE_START_UTC |
datetime |
Last Use Start |
|
|
ON_CLOSE_SQL_DURATION_MS |
int32 |
SQL On Close Duration (ms) |
☐ |
|
ON_CLOSE_SQL_START_UTC |
datetime |
SQL On Close Start (UTC) |
☐ |
|
ON_CLOSE_SQL_STATEMENT |
string |
SQL On Open Statement |
☐ |
|
ON_OPEN_SQL_DURATION_MS |
int32 |
SQL On Open Duration (ms) |
☐ |
|
ON_OPEN_SQL_START_UTC |
datetime |
SQL On Open Start (UTC) |
☐ |
|
ON_OPEN_SQL_STATEMENT |
string |
SQL On Open Statement |
☐ |
|
PREVIOUS_CONTEXT_DESCRIPTIONS |
string |
Previous Context Descriptions |
|
|
SERVER_VERSION |
string(240) |
Server Version |
|
|
USAGE_PERCENTAGE |
int32 |
Usage (%) |
☑ |
|
12-12-2020 18:19 Version 20.1.301-BETA+3023