Confirmation the parameter "free connections" is monitoring the connections or sessions of the sqlserver Database

Products

• Unified Infrastructure Management for Mainframe

Issue/Introduction

How to confirm that the parameter "free_connections" is monitoring the connections or sessions of the sqlserver Database.

Resolution

Run 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  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.