Skip to Content
avatar image
Former Member

MOM alert SQL Server User Connections are more than 500

Hi,

I am getting the following alert from MOM at least once in a week.

SQL Server User Connections > 500

SQLServer:General Statistics: User Connections: value = 503

When i am searching about this, i got the following SQL link.But its not contain how to resolve this or which parameters should be monitor.

[SQL Microsoft link|http://technet.microsoft.com/en-us/library/cc723729.aspx]

You can find another link, here they are telling that It's a bug in the SQL MP and we can ignore.

[http://www.eggheadcafe.com/software/aspnet/29114626/mom-2005-reporting-over-4.aspx]

I didnt got any proper hint to resolve this.

Could you tell me how serious it is and which precautions should be taken?

or really can we ignore this?

Regards,

Nagendra.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 31, 2008 at 10:50 AM

    This is really not a SAP question... is more about MOM alerts.

    Anyhow... The only reason the alert is been triggered is because the threshold for the alert in MOM is been reached... if this is a problem or not pretty much depends on your landscape and the settings of you MSSQL DB... but having 500 or 503 user connections does not represent a thread as long as your environment can handle the load... if thats the case then you can Ignore or change the threshold

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

    • I want to know which precautions we can take from SAP level.

      From SAP point of view just make sure that theres enough sessions available and if thats the case then simply ignore the alert.

      Regards

      Juan