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

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.