Thanks a lot for the advice. I will run the sp_configure and split the amount of memory so that it adds up to 3GB. Our UAT server will probably get a little more because it is client facing.
Steve,
The reason why we have 3 instances on one server is because we are a fairly small shop with a tight budget. We have our database servers on their own but our dev/stg/uat environments are clustered together for both our 2000/2005 instances.
Even though I am pretty much the only guys keeping those servers alive, I have been asking for help on the admin side since I joined the company and the only reply I get is: "There is no need for it." We have about 20 developers in hours and only a couple of them (me included) are really interested in SQL development / database administration / establishing SQL standards / promoting tighter security...
Anyway, thank you again for the post. Very much appreciated.
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999