Solved

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

Posted on 2004-10-11
4
133 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 95

Accepted Solution

by:
Lee W, MVP earned 500 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
 
LVL 95

Expert Comment

by:Lee W, MVP
ID: 12390276
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Often, people trade privacy and security for convenience. However in today's concrete jungle, this is an extremely foolish decision considering the vast amount of technologies being used against consumer interest. First off, I won't waste any time e…
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…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now