Hi,

In one of my application JBO(Juniors Backoffice), whenever any user login onto the application there are 90 process are open and it was found that the connection management on the application level was not done efficiently. Now the problem is if 10 users are login onto the system than there are 900 processes are open in the system and these processes are laying in the system unless until the user logout from the system. The time comes when the maximum limit of the process reaches, there might be the chances of crashing the system.

Is there any ways to manage this situation from Backend.

Thanks to all.

R Mohanty
DBA
Netcradle Ltd.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page