Well, what I'm really trying to solve is an issue with what I can only consider shared memory. I have an application that is pretty dated in it's design. Without modifying the app, I need to figure out a way to boost it's performance. If I put it on the db server, performance is great. If I split them, I'm not going to say it's bad, but I want it better. Putting it on the db server doesn't scale.
The application uses a lot of cursors and so it has a lot of memory overhead. From what I understand of the app/db relationship, if you put them on the same server as the db, it's using shared memory instead of ODBC and TCP/IP to do the work. If you split the machines, all those cursors are transferring lots of little bits over ODBC to TCP/IP, back down through ODBC again, etc, etc.
My hope was that I could get two VM's on a 10Gbps channel to outperform what we've had so far with a split app/db.
My test was to copy an 80GB file from one Vm to the other. The best throughput I can get is just over 1Gbps. I was really hoping to get 4 or 5 or 6 Gbps, but I'm going to start running some performance tests on the application at this speed to see if it makes a difference.
Thanks for responding. This is a can of worms, I know. My baby won't sleep, so I figured I'd drop something in here.
Joe