These connections are required by assp!

>tied up 199 connections

depending on the configuration , the number could be much higher

>so it doesn't choke the SQL

what chokes a SQL server a sleeping (idle) connection ?

Thomas


Von:    "Kevin Summers" <[email protected]>
An:     <[email protected]>, 
Datum:  14.10.2012 04:26
Betreff:        [Assp-user] ASSP Maxes out MSSQL Server.



ASSP seems to be taking up all available connections to my MSSQL Server
It has tied up 199 connections that for the most part appear to be 
sleeping.

Is there a way I can decrease this in ASSP so it doesn't choke the SQL
Server
and bring the whole system to a crawl?

 

Kevin Summers

KISTech Studios

Photography & Video

------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Assp-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-user




DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally 
privileged and protected in law and are intended solely for the use of the 

individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no 
known virus in this email!
*******************************************************


------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Assp-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-user

Reply via email to