Solved

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

Posted on 2004-09-13
15
282 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

This article is in response to a question (http://www.experts-exchange.com/Networking/Network_Management/Network_Analysis/Q_28230497.html) here at Experts Exchange. The Original Poster (OP) requires a utility that will accept a list of IP addresses …
We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 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