Solved

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

Posted on 2004-09-13
15
281 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

831 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