---
title: "PooledConnections (SQL Server)"
description: "Pooled Connections"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Invantive.PooledConnections
original: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Invantive.PooledConnections
updated: 2026-11-18T23:25:39Z
license: https://documentation.invantive.eu/en/
---

# PooledConnections: SQL Server Pooled Connections

`read only`

- Catalog: `Database`
- Schema: `Invantive`
- Label: Pooled Connections

Can only retrieve data.

## Table Columns

The columns of the table `PooledConnections` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `CONNECTION_TIMEOUT_SEC` | `int32` | Connection Time-out (sec) | [x] |  |  |
| `COUNT_TIMES_USED` | `int32` | Number of Times Used | [ ] |  |  |
| `CREATED_UTC` | `datetime` | Date Created | [ ] |  |  |
| `CURRENT_CONTEXT_DESCRIPTION` | `varchar2(240)` | Current Context Description | [ ] |  |  |
| `CURRENT_CONTEXT_NATURAL_KEY` | `varchar2(240)` | Current Context Natural Key | [ ] |  |  |
| `CURRENT_CONTEXT_USER_LOG_ON_CODE` | `varchar2(240)` | Current Context User Log On Code | [ ] |  |  |
| `DATABASE` | `varchar2(240)` | Database | [ ] |  |  |
| `DURATION_USED_MS` | `int32` | Duration Used (ms) | [ ] |  |  |
| `ID` | `int32` | ID | [ ] |  |  |
| `IS_FREE` | `char` | Is Free | [x] |  |  |
| `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` | `varchar2` | 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` | `varchar2` | SQL On Open Statement | [ ] |  |  |
| `PREVIOUS_CONTEXT_DESCRIPTIONS` | `varchar2` | Previous Context Descriptions | [ ] |  |  |
| `SERVER_VERSION` | `varchar2(240)` | Server Version | [ ] |  |  |
| `USAGE_PERCENTAGE` | `int32` | Usage (%) | [x] |  |  |

