Why guess and speculate on opinion? 1) Run the DP Monitor on all three boxes (/AD on - freakishly low overhead system and per process monitoring with extreme accuracy laid out graphically, and actually MEASURE and KNOW definitively how much RAM you will need under any/all conditions. www.deltek.us - tell them CheetahFTL referred you - /AD off ). 2) Bag the XP Pro, go W2K3 Server or better yet, Linux.. 3) Add RAM to SQL Boxes, and keep each SQL DB on its own box, and increase NIC card, all network & cabling capacity to handle 100 MB or GB Networking. 4) Monitor pro-actively going forward.
Regards, Scott ----- Original Message ----- From: "Charles Barouch" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Monday, March 12, 2007 2:51 PM Subject: [U2] How much RAM is too much > All, > I need some opinions! I have a client who is willing to spend to put > up a nice sized box, but they only want to spend once. Here's what they > need to do: run a 4 user copy of Universe, holding a Type 30 file with a > mere 200k records. Requests will range from give me one record (average > size is under 200 bytes) to give me all records. > The catch is that two SQL databases, with criminally slow network > connections will be feeding a fresh set of records every hour. > I need a recommendation on how much RAM and Processor to throw at > the system so that SQL joins (6 levels deep) don't slow down the > UniVerse part of the system. The response time has to be obscenely quick > (eCommerce for a very, very busy site). > All thoughts appreciated. > > -- > > Charles Barouch ([EMAIL PROTECTED]) > www.KeyAlly.com (718) 762-3884 x 1 > P. O. Box 540957, Queens, NY 11354 > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
