The IN_DB_UTIL_SP_DB_CONNECTIONS_COUNT will return the total number of connections to the database and the number of active connections to the database.
| Parameter | Description | |
|---|---|---|
| TOTAL_CONNECTIONS | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | NULL | |
| Description | Returns the total number of connections to the database. | |
| ACTIVE_CONNECTIONS | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | NULL | |
| Description | Returns the total number of active connections to the database. | |
| V_RETURN_VAL | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description |
Specifies whether the execution of the procedure was successful or not 0 = Success 1 = Error |
|
Examples
DECLARE
@TOTAL_CONNECTIONS INTEGER,
@ACTIVE_CONNECTIONS INTEGER;
BEGIN
EXEC IN_DB_CONNECTIONS_COUNT
@TOTAL_CONNECTIONS = @TOTAL_CONNECTIONS OUTPUT,
@ACTIVE_CONNECTIONS = @ACTIVE_CONNECTIONS OUTPUT;
PRINT 'TOTAL_CONNECTIONS = '+CONVERT(VARCHAR,@TOTAL_CONNECTIONS);
PRINT 'ACTIVE_CONNECTIONS = '+CONVERT(VARCHAR,@ACTIVE_CONNECTIONS);
END;
GO