?
Solved

Help to decide between a single or mutiple windows 2000 / 2003 servers

Posted on 2004-10-11
4
Medium Priority
?
142 Views
Last Modified: 2010-04-14
Hi experts,

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).

Thanks,

Carlos V.
0
Comment
Question by:CARLOSVILLACRIZ
  • 2
  • 2
4 Comments
 
LVL 97

Accepted Solution

by:
Lee W, MVP earned 1500 total points
ID: 12283843
You don't mention the kind of CPU the server has or if it's dual capable.  

What I'd suggest you do is setup 2 servers.

Server1 = Domain Controller (and operations masters), File Server
Server2 = Database server (Oracle, SQL), Domain controller

File services and domain functions don't typically stress a server, ESPECIALLY in an environment of 15 users.  Keeping the database on those servers might end up slowing file access down.  Likewise, accessing files might end up slowing database access.

Having two DCs will help ensure that if one crashes, your active directory settings and file security isn't lost.

The database server you might want to consider getting dual CPUs.  The fileserver/DC could be whatever you're using now.

By the way, what do you do for backups?  Critical files could be scripted to be backed up on the other server so that you have a live backup every so often.  In addition, if you upgrade to 2003 server, you could enable Volume Shadow Copy on the fileserver.  This effectively lets your users recover previous versions of files, in the event they accidentally overwrite something.
0
 

Author Comment

by:CARLOSVILLACRIZ
ID: 12365958
Thanks leew,

I'm doing backups manually by now.. can you give me a references to read about volumen shadow copy? is it fast and secure? this copy must be done when the users are not working?

Carlos V.
0
 

Author Comment

by:CARLOSVILLACRIZ
ID: 12390153
Thanks leew, I'd like to send me some references about shadow copy.. I'm about to configure my network using your suggestion, and I'm interested to know easy to read and practicle articles about best practices of backup with windows 2003. I hope I don't need to write another question about this.. only give me some good links please...

Carlos V
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am posting this in case anyone runs into similar issues that I did, this may save you a lot of grief: Condition: 1. Your NetBIOS domain name contains an ampersand " & " character.  (e.g. AT&T) 2. You've tried to run any Microsoft installation…
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question