G'Day Fellas/Sheilas LOL got your attention Eh, Crickey, 'ere is my question,
Just a quick question, I have four servers 1: a report database, 2: A web server/ASP server, 3: A login and storage server and 4 a work server.
What happens is this, a user logs in through the web via asp on server (2) which checks their logins against a database on server (3). This server then collects the sql from storage and sends it to (4) to process. Server (4) sends the sql to server (1) which contains the database to be queried. When it has a result set, it sends it back to server (4) which performs any nessecary calculations etc, and then it is passed back to server (2) for loading into asp pages to be sent back to the user.
confused, no, good.....
Now I hear you saying this is a pretty complex way of getting some data, but, a big but (like me), ther are hundreds of people sending requests for different queries during the same time frame, we have around 2000 users, with approx 20 to 50 be concurrent, with around 100-200 logged in at peak times.
All four servers have two nics, and three of the four need to be accessable via the standard enterprise WAN as well.
What I enviaged was to give the three (1,2,3) access to the network via one nic, and to creat a totally private network amoung the four using the other nic. This would stop enterrise traffic from slowing down the processes within the four servers, besides some cpu usage (they all have 4 cpu's) and I believe would enable significantly faster results. Currently, result times appear more a product of network speed then processing speed.
Can what I want be done. Note a boreing ol' yes/no gets 10 points
If not why not (100 points)
Have you a better solution (200 points)
with instructions notes diagrams and asprin (500 points)
Waiting anxiously for your help and assistance as always