difference btw MTS and Dedicate server

[Phil]

Hi can anybody tell what's different between Multiple Thread Server and
Dedicate server.
I mean I know the basic stuff about these two servers, but in what
environment we need to choose either MTS or dedicate server.

I read the book, it says dedicate server allow DBA to monitor each user,
since it is one session per user.
So I thank MTS only want to save some system resource. Is that right?

Thanks

Phil

[Brad]

G'Day,

In article <0_ji5.6713$0W4.2...@newsread2.prod.itd.earthlink.net>,

"Phil" <phil...@amax.com> wrote:
> Hi can anybody tell what's different between Multiple Thread Server
and
> Dedicate server.

Basically, MTS has a "pool" of server processes (often 5-10 are used)
which are shared amongst user connections. For Dedicated server mode,
one server process is created for each user connection.

> I mean I know the basic stuff about these two servers, but in what
> environment we need to choose either MTS or dedicate server.

The biggest factor for me is memory usage. I know that for VMS, and
I believe it's similar for Unix, each server process requires about
4-5Mb of RAM. So if you have heaps of spare RAM or not too many
users, dedicated server is fine. It's also easier to implement :-)
If you're a bit short of RAM, try using MTS and put the RAM towards
more needy purposes (buffer cache etc).

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Brad van Eps van...@my-deja.com
OS/2 WARPed for REAL power!
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Sent via Deja.com http://www.deja.com/
Before you buy.

[bm lam]

Phil schrieb:

> Hi can anybody tell what's different between Multiple Thread Server and
> Dedicate server.

> I mean I know the basic stuff about these two servers, but in what
> environment we need to choose either MTS or dedicate server.
>

> I read the book, it says dedicate server allow DBA to monitor each user,
> since it is one session per user.
> So I thank MTS only want to save some system resource. Is that right?
>
> Thanks
>
> Phil

I think MTS is probably designed for database which have hundreds, if not
thousands users connected simultaneously. Obviously, having a dedicated
server process for each client, where the client may be idle 99% of the
connection time, would be a tremendous waste. But then I heard that for
shops that have this kind of user population, third party tools like Tuxedo
is employed. So pure MTS might be more suitable for shops that are some
between a 10-users-shops and those ones