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.
Release : 9.0.2
Component : UIM - SQLSERVER
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.