Solved

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

Posted on 2004-09-13
15
279 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:tsbathe
Comment Utility

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
Comment Utility
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
Comment Utility
How many users are accessing it?
0
 
LVL 15

Expert Comment

by:Yan_west
Comment Utility
Btw, 200000 records is not that large :)
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:tsbathe
Comment Utility

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
Comment Utility

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
Comment Utility
You wont have any problems then.. be sure to have large amount of ram :)
0
 
LVL 15

Expert Comment

by:Yan_west
Comment Utility
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
Comment Utility

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
Comment Utility

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

Expert Comment

by:Yan_west
Comment Utility
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
Comment Utility

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

The Need In an Active Directory enviroment, the PDC emulator provide time synchronization for the domain. This is important since Active Directory uses Kerberos for authentication.  By default, if the time difference between systems is off by more …
Resolve DNS query failed errors for Exchange
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 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

9 Experts available now in Live!

Get 1:1 Help Now