Simple network questions

Johnny · Post by **Johnny** » Mon Oct 04, 2004 6:55 pm

Question One

==========

I have a database that sits on Machine A. I have an application which is deployed on Machine B. When I run the application on Machine B, what memory requirements does this make on Machine A?

More questions to follow ...

wolf0564 · Post by **wolf0564** » Mon Oct 04, 2004 7:07 pm

Johnny, sorry if this is too ignorant, but did you try running the process on B and running Taks Manager (on XP) or top on unix on A and seeing what's going on?

Johnny · Post by **Johnny** » Mon Oct 04, 2004 7:10 pm

No I didn't. It's a hypothetical question. I'm trying to decide how to set up a system. Perhaps someone else could oblige by trying out this experiment?

wolf0564 · Post by **wolf0564** » Mon Oct 04, 2004 7:12 pm

ok, let me try

Johnny · Post by **Johnny** » Mon Oct 04, 2004 7:51 pm

Thanks dude

wolf0564 · Post by **wolf0564** » Mon Oct 04, 2004 7:51 pm

ok, B used to access (read/write ) onto the db on A: for read/write. CPU on A is beign used reasonably hard while memory usage stays flat. Both CPU and mem. on B were being used.

hope that helps!

Johnny · Post by **Johnny** » Mon Oct 04, 2004 7:53 pm

Thanks a lot. That's very interesting. So to confirm it is using CPU power on A, but not really using memory on A?

wolf0564 · Post by **wolf0564** » Mon Oct 04, 2004 8:09 pm

that's right. sort of makes sense, if it has to re-package all those bits and showel them down the network... oh, and also my A was a PIII and my B was Xeon, so perhaps the CPU usage would be comparable in relative terms...

monkeyA · Post by **monkeyA** » Mon Oct 04, 2004 8:22 pm

that sounds about right for most database operations. if you are going to do something like a full table copy etc. you might use more memory on the database server.

memory is cheap, shouldn't be an issue.

asd · Post by **asd** » Tue Oct 05, 2004 2:32 am

"I have a database that sits on Machine A. I have an application which is deployed on Machine B. When I run the application on Machine B, what memory requirements does this make on Machine A?"

I think it might depend on how efficient the database program is, and what method is employed for doing the query. eg., If a very large dataset is returned from a query on machine A , all the data is not necessarily sent to machine B. Depeneding on configuration or query parameters, a cursor cache can be maintained.

If a disconnected recordset is requested, all memory load is taken by B after query is executed. (Again, it depends on internal implementation of database software. Some might even cache it after returning a disconnected recordset. )