Confirmation that the parameter "free connections" monitors the connections or sessions of the sqlserver Database
search cancel

Confirmation that the parameter "free connections" monitors the connections or sessions of the sqlserver Database

book

Article ID: 204183

calendar_today

Updated On:

Products

Unified Infrastructure Management for Mainframe

Issue/Introduction

The database team tells me to confirm that the parameter free_connections "monitors the connections or sessions of the sqlserver Database," please if you can help me answer this question.

Environment

Release : 9.0.2

Component : UIM - SQLSERVER

Resolution

Here is the underlying sqlserver checkpoint query:

select (select cntr_value from sys.dm_os_performance_counters where
LTRIM(RTRIM(object_name)) LIKE '%:General Statistics' AND LTRIM(RTRIM(counter_name))
= 'User Connections') connections, (select convert(dec(15),value_in_use)
from sys.configurations where configuration_id = 103) config_connections,
convert(dec(12,0),@@MAX_CONNECTIONS) max_connections

Here is some sample output showing that it is the number of connections as per the query results:

connections config_connections max_connections
314              0                              32767

The user connections counter refers to connections that are not system connections.