See, it's advice like that that get applications like this busted. Did
you even think to ask if this was client/server vs. multi-tiered? No.
Multi-tiered, yep, pooling is the way to go.
Client/Server, wow, you see this right here, all the time. Because
developers don't do their homework.
Anthony Thomas, MCDBA, MCSA
-----Original Message-----
From: Adam Albina
[mailto:mssqldba-ezmlmshield-x51456674.[Email address protected]
Sent: Wednesday, August 25, 2004 7:56 AM
To: LazyDBA Discussion
Subject: RE: Serious Problem
This is a bit more severe than "connection management on the application
level was not done properly". This is an application developer who
needs some schooling. I'm afraid there is nothing global you can do
from the backend - the problem is with the front end. This application
needs to be re-written to use connection caching and connection pooling.
Most ADO or OLEDB implementations do this for the developer - so it
should be fairly easy for them to implement if they can read up on it a
bit. I can't imagine an application - even a multi-threaded complex
financial application that needs 90 threads with 90 connections to the
database. Imagine trying to keep all those threads synchronized...
It's often a good idea to have a development SQL Server so that these
things can be discovered early on in the development cycle when it's
much easier and less costly to modify the application design.
Best of luck - my recommendation would be to deny the application use of
the server. Many production databases use an application authentication
scheme to make sure that only authorized applications can access the
DBMS.
Adam
Adam R. Albina
Director of Information Technology
Saint Anselm College
100 Saint Anselm Drive, P.O. Box 1711
Manchester, NH 03102
[Email address protected]
603.641.7266 603.801.9587(Mobile) 603.641.7288(Fax)
-----Original Message-----
From: Rajendra Mohanty
[mailto:mssqldba-ezmlmshield-x34576464.[Email address protected]
Sent: Wednesday, August 25, 2004 7:52 AM
To: LazyDBA Discussion
Subject: RE: Serious Problem
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]
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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]
***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************
MS Sql Server LazyDBA home page