We'd like to optimize our network environment. We're about 15 users in our LAN and our job is software development. We frequently test our software trying to stress it. New projects are coming and have a huge project folder. By now we have only one windows 2000 server that is our domain controller, SQL Server, Oracle Server and File Server. It has 1GB of memory and about 160GB of HD.
Task manager shows that sql server is using more than 50% of CPU and Memory. I don't know what's the impact in the performance of our environment. I know that write cache is disabled in the domain controller, I think it could make the server slower.
What I'm thinking is to have an environment with:
01 Windows 2000 / 2003 Server - Domain Controller only
01 Windows 2000 / 2003 Server - File Server only
01 Windows 2000 / 2003 Server - Oracle and SQL Server only
I'd like to know if I have this kind of environment we'll gain a lot of performance in all our network activities. If we won't have a significant improvement simply will continue working with our server (probably we would upgrade the hardware).