We currently have 2 servers that take the load of most of our activity. My problem is that we're already running into extreme slow-downs (waiting 30-2 minutes to be able to type/click) because of memory issues on our main server (Server A). I've already tried restricting the memory allocation for all the SQL instances (some were taking more than a Gig). I just lowered the max memory allocation again and will wait to see if that helps more consistently.
My other problem is we might be adding another 5 users that will be VPNing into the same server in a couple months, and I need to be able to support them. Since i'm on a 32 bit server and OS, i can't get more than the 4GB i have already so i'm wondering what my best options are.
Can I just get a new 64 bit server (Windows Server 2010 on it? or 2003 since the rest of my servers are 2003?), and make that my SQL server and file server. Then keep Server A as my DC, VPN, and Exchange Server, and my terminal server as is?
Any advice or help would be appreciated!
Server A is our DC, VPN endpoint, Exchange Server, SQL Server, and File Server.
Specs: SBS2003; PowerEdge 840 w/ Xeon 2.4 Ghz and 4GB Ram with 1TB in Raid 5.
Server B is our Terminal Server ~22 people log into it concurrently during the day and use various apps (OpenOffice, Internet, Enterprise Software, etc).
Specs: Server 2003 R2 Standard. PowerEdge 840 w/Xeon 2.4 Ghz and 4GB Ram with 250GB in Raid 5 and a 32GB SSD for the page file.