PDA

Click to See Complete Forum and Search --> : is this the biggest prob ever encountered??


Kunchesm
May 1st, 2002, 01:52 PM
hi

We r working in 3-tier environment with VB6 as front end, Middle tier (Dlls also in VB6), and Oracle 8i as back end and Win 2000 OS.
We hav a network of about 400 odd win 2000 systems...all our applications are running perfectly....but now all of a sudden vr caught in a problem....all the applications hav gone slow and frequently vr getting "SWITH TO RETRY " Problem and the call time for the Components (in COM+) are increasing ...can any one pl help us solve the prob...

can anyone atleast guide me where i can find the solution....

plzzzzzzzzzzz let me know ur views / ideas even though they r not exact solutions....

ThanX in Advance.
Ksm


__________________

Arc
May 2nd, 2002, 01:21 AM
Use Out of process componenets and set them the to SingleUse. Also set the thread pool to a relitively high number.. say 10-15. Make sure the Unattended_Execution box is checked. Or you can use the Thread per object option(Although that can become real server intensive).

If you decide to stay with in process components then make sure they are apartment threaded(which they are by default).

Also Maybe you could look at placing the DLL's/ActiveX exe's on a nother server so as to relieve some pressure off the one with the DB?