Page 1 of 2
Simple network questions
Posted: Mon Oct 04, 2004 6:55 pm
by Johnny
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 ...
Simple network questions
Posted: Mon Oct 04, 2004 7:07 pm
by wolf0564
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?
Simple network questions
Posted: Mon Oct 04, 2004 7:10 pm
by Johnny
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?
Simple network questions
Posted: Mon Oct 04, 2004 7:12 pm
by wolf0564
ok, let me try
Simple network questions
Posted: Mon Oct 04, 2004 7:51 pm
by Johnny
Thanks dude
Simple network questions
Posted: Mon Oct 04, 2004 7:51 pm
by wolf0564
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!
Simple network questions
Posted: Mon Oct 04, 2004 7:53 pm
by Johnny
Thanks a lot. That's very interesting. So to confirm it is using CPU power on A, but not really using memory on A?
Simple network questions
Posted: Mon Oct 04, 2004 8:09 pm
by wolf0564
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...
Simple network questions
Posted: Mon Oct 04, 2004 8:22 pm
by monkeyA
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.
Simple network questions
Posted: Tue Oct 05, 2004 2:32 am
by asd
"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. )