Solved

Server 2003 box for file/print and SQL/IIS with 100 users. Single or separate servers?

Posted on 2004-09-13
15
283 Views
Last Modified: 2010-03-18


I am migrating my office of 100 users from netware to a windows enviornemt. I purchased a Dell PowerEdge 4600 with the following specs:

1. RAID 5 with 180gb avaible for use (SCSI 10k drives)
2. 2.8ghz Intel Xeon Processor
3. Redundant power supplies
4. Gigbit nic plus 2 additional nics
5. Other goodies

This is going to be a file and print sharing server but I also will need to run SQL server and IIS to serve a few applications I wrote. My question is, can I put SQL and IIS on this server or should I setup a separate server for these. SQL and IIS will have minimal traffic with, at most, 30 people accessing it at the same time. And as far as file sharing goes, we deal with small word and excel files.

Any input would be appreciated. Thanks!

0
Comment
Question by:tsbathe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
  • 2
15 Comments
 
LVL 15

Expert Comment

by:adamdrayer
ID: 12047165
how big are the databases you will be querying, who wrote the sql that accesses them?  how good were they?  It's hard to say.  SQL can put a hurt on CPU for real time-intensive querying.  I would say to seperate the SQL from everything else.  If the queries don't last very long (<1sec. average), then it may not be so bad.  if you have the resources, and expect any kind of growth in users or data, then i would say seperate them.
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 12047574
Yes you can, it all depends on the kind of load you will be putting on your sql Server..  I usually prefer to separate everything, but if you are tight with your budged, add up a second Processor..
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 12047588
Btw, if you add up a second processor, check your licensing with your Sql server.. if you bought a 1 Cpu license, you may need to buy one for a 2nd processor.
0
Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

 

Author Comment

by:tsbathe
ID: 12048178

I have two larger databases and a few very small ones. The one database has about 10 tables with 2 of them containing around 200,000 records and slowly growing. Users enter and delete data with an off the shelf application used for keeping track of their time. I wrote the code for generating the reports in crystal reports. There is only 2 tables in the other database but 1 is 250,000 records. I wrote the SQL code but it very simple and is just used for displaying the data in various ways.

My SQL license is for a single processor. This is a government office so I am on a budget. I do have an older Compaq server that could be used. 700mhz P3 with two 36gb scsi drives. Its not the best so I wasnt sure if using the newer server for everything would be better.
0
 
LVL 15

Expert Comment

by:adamdrayer
ID: 12048244
Well, it sounds like it's a practice management application.  That's fine.  I was expecting a high-intensity website.  You SHOULD be able to squeak by with one server and decent performance.
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 12048253
How many users are accessing it?
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 12048261
Btw, 200000 records is not that large :)
0
 

Author Comment

by:tsbathe
ID: 12048337

I have about 75-90 users connecting for file and print. For SQL and IIS, I have about 20-35 users connecting at most at any given time. And they are not running huge queries.

All of the web applications they use are written in .NET and use stored procedures. I dont know if this makes a difference or not.

0
 

Author Comment

by:tsbathe
ID: 12048374

Yeah, I know 200,000 isnt that large. But compared to the other databases it is. Ha.

This app has been running on an access database. It was very sad as you can imagine. I just recently moved it over with the new hardware.

Thanks again!

0
 
LVL 15

Accepted Solution

by:
Yan_west earned 125 total points
ID: 12048493
You wont have any problems then.. be sure to have large amount of ram :)
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 12048503
Btw, is you IIS published on the web? That's very bad thing if it is.. not secure at all with everything running on there.. + It's a DC..
0
 

Author Comment

by:tsbathe
ID: 12048508

Do you think a gb is sufficient?

I wanted to go for 2 but they whined. I could probably get some more if needed. New fiscal year and all.
0
 

Author Comment

by:tsbathe
ID: 12048526

Oh no, its not on the web. This is strictly a departmental intranet.
0
 
LVL 15

Expert Comment

by:Yan_west
ID: 12048528
In any case, you should check out your memory utilization at peak hours, when everyone is working hard.. Don't go with more then 2GB btw.. some application like exchange do not run well with more then 2gb of memory..
0
 

Author Comment

by:tsbathe
ID: 12048567

Cool, thanks for all the feedback. I'll go with the single server for now. It can always be moved later. Thanks!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
Resolve DNS query failed errors for Exchange
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 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