Re: Performance advice

> "L.Shaw" <lyndons@enterprise.net> wrote: > The only consideration I have by separating the database on its > own machine is the ability to run applications through shared memory, > but > as I said before there is little difference between this and a TCP/IP > loopback. > The TCP/IP loopback device has nothing to do with network speed or capacity.It's simply an internal UNIX construct which acts similar to /dev/null. You need to run your test program from a representative node on each segment of your network and then compare it to the speed achieved via hosts communicating on an isolated network ( you could just unplug all other hosts from your hub or use a hub faking cable -- but that incurs a little performance hit also ) to get a solid idea of whether or not network performance is an issue. However, judging by the type of applications you are talking about ( mostly batch ) I doubt that the network is your bottle neck. Chart the output from sar over a week or two and you may start to see pointers toward the problem. Good Luck Jerry Champlin, ESP Software Services, jchampli@cotl.com