Solved

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

Posted on 2004-09-13
15
284 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

A brief overview to explain gateways, default gateways and static routes OR NO - you CANNOT have two default gateways on the same server, PC or other Windows-based network device. In simple terms a gateway is formed when a computer such as a serv…
Have you ever set up your wireless router at home or in the office to find that you little pop-up bubble in the bottom right-hand corner of Windows read "IP Conflict - One of more computers on the network have been assigned the following IP address"…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

696 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