Number of User Connections

[Former Member]

Is there a way to monitor the maximum number of user connections from Solution Manager?

[former_member207908]

Hi Ashwin,

By "monitoring" if you mean the checking the configured part, following is the navigation

SOLMAN-->DBACOCKPIT-->Configuration-->Server configuration-->Memory Use-->number of user connections

If you are looking for "dynamic" usage of this parameter,

using DB02-->Performance -->Dash board-->Connections

will give you information of active, free and reuse count values.

Also,sp_monitorconfig "number  of user connections"

will give you same results using isql.

HTH

Rajesh

[former_member182259]

Rajesh's reply gives the ways to find the maximum number of user connections in the entire server.  However, if you are trying to find the maximum number of user connections for a certain application, the only way to get that information is by reviewing the monProcess monitoring data history (assuming you don't have login auditing or other such facility enabled)..... monProcess data is collect by saptools and is exposed via DBACockpit (I think) - you would just need figure out which fields to search on

[Former Member]

Thanks for the responses. Iam aware that we can have this monitored via the DBACOCKPIT. Iam trying to find if there is way or a metric in solman template that can be used to be alerted if the max connections reaches to the configured value.

[JanStallkamp]

Hi.

As of today the number of used user connections is not part of the technical monitoring templates we ship for SAP ASE and it's not included in the data providers used for the metric and alert infrastructure (MAI).

So you will need to program your own data provider and add the metric to the template.

Regards,

Jan