Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

new server class hardware, better for IIS or SQL Server?

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  Loosing ASP.NET sessions  
Author Message
user3329

External


Since: Dec 16, 2004
Posts: 12



(Msg. 1) Posted: Thu Feb 24, 2005 12:29 pm
Post subject: new server class hardware, better for IIS or SQL Server?
Archived from groups: microsoft>public>inetserver>iis (more info?)
I am lucky enough to be the proud owner of an previously loved P3 350Mhz,
dual Xeon processor with 1GB of RAM and six SCSI RAID 9GB HDs. Would this
server class box be better served as an IIS server or as a SQL Server
machine?

I'm currently running IIS on an 800Mhz with 256MB and a 40GB HD. And my
current SQLServer box (doing double duty as a mail server too) is a P3
650Mhz with 192MB and a 10GB HD.

Any suggestions? I'm considering taking the RAM out of the server box and
putting it into my SQL Server box, but I'm not sure if that would be the
best use of the hardware.

Any ideas would be greatly appreciated. Thanks

 >> Stay informed about: new server class hardware, better for IIS or SQL Server? 
Back to top
Login to vote
user1772

External


Since: Jun 10, 2004
Posts: 1807



(Msg. 2) Posted: Fri Feb 25, 2005 3:42 am
Post subject: Re: new server class hardware, better for IIS or SQL Server? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Thu, 24 Feb 2005 12:29:43 -0500, "Flip"
<[remove_me]phenry_w@hotmail.com> wrote:

 >I am lucky enough to be the proud owner of an previously loved P3 350Mhz,
 >dual Xeon processor with 1GB of RAM and six SCSI RAID 9GB HDs. Would this
 >server class box be better served as an IIS server or as a SQL Server
 >machine?

Probably.

 >I'm currently running IIS on an 800Mhz with 256MB and a 40GB HD. And my
 >current SQLServer box (doing double duty as a mail server too) is a P3
 >650Mhz with 192MB and a 10GB HD.
 >
 >Any suggestions? I'm considering taking the RAM out of the server box and
 >putting it into my SQL Server box, but I'm not sure if that would be the
 >best use of the hardware.
 >
 >Any ideas would be greatly appreciated. Thanks

Nobody can answer. We have no clue what the load on any server is,
whether you're seeing any bottlenecks or what other factors might
change the performance. SQL requires an additional license for the
dual processor if it makes a difference. But if you're running SQL on
a 192MB 10GB box now you'll never need a second processor anyway.

Jeff<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: new server class hardware, better for IIS or SQL Server? 
Back to top
Login to vote
qbernard1

External


Since: Dec 23, 2003
Posts: 905



(Msg. 3) Posted: Fri Feb 25, 2005 4:35 am
Post subject: Re: new server class hardware, better for IIS or SQL Server? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
There's no fix formula on this, it all depend on your app.
you need to collect performance data then evaluate the needs whether it's
hardware bottleneck or software issues.

next, based on my experience. for IIS - you need CPU power, ram size (depend
on app), SQL - the more memory you can dump in the better Smile

--
Regards,
Bernard Cheah
<a style='text-decoration: underline;' href="http://www.tryiis.com/" target="_blank">http://www.tryiis.com/</a>
<a style='text-decoration: underline;' href="http://support.microsoft.com/" target="_blank">http://support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.msmvps.com/bernard/" target="_blank">http://www.msmvps.com/bernard/</a>



"Flip" <[remove_me]phenry_w@hotmail.com> wrote in message
news:%23ko22ZpGFHA.2504@TK2MSFTNGP10.phx.gbl...
 >I am lucky enough to be the proud owner of an previously loved P3 350Mhz,
 >dual Xeon processor with 1GB of RAM and six SCSI RAID 9GB HDs. Would this
 >server class box be better served as an IIS server or as a SQL Server
 >machine?
 >
 > I'm currently running IIS on an 800Mhz with 256MB and a 40GB HD. And my
 > current SQLServer box (doing double duty as a mail server too) is a P3
 > 650Mhz with 192MB and a 10GB HD.
 >
 > Any suggestions? I'm considering taking the RAM out of the server box and
 > putting it into my SQL Server box, but I'm not sure if that would be the
 > best use of the hardware.
 >
 > Any ideas would be greatly appreciated. Thanks
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: new server class hardware, better for IIS or SQL Server? 
Back to top
Login to vote
user3329

External


Since: Dec 16, 2004
Posts: 12



(Msg. 4) Posted: Fri Feb 25, 2005 10:23 am
Post subject: Re: new server class hardware, better for IIS or SQL Server? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thank you Bernard and Jeff for your ideas. You gave me a few things to
think about. I'm actually thinking of trying my hand at some C# code to see
if I can whip something up to run some tests. Write a million lines to the
db, read that data a thousand times and write it to a new file. Not
perfect, but helps me learn c# and will give me an idea on hw performance.

Thanks again guys! :>
 >> Stay informed about: new server class hardware, better for IIS or SQL Server? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
suggest a good hardware load balancer? - I know Windows 2003 supports load balancing, but I already have two Windows 2000 web servers and now I want to run the same websites on both and put a hardware load balancer in front. Can anyone suggest a good make/model? Also, with the hardware load..

Class not registered - I am using IIS 6.0 on Windows 2003 server. When I use the iissamples/iissamples/default.htm to search for a word and then click Full or Summary to show the Hit highlighting words, I get a page that just says - Class not registered. Does anyone know..

Windows 2003 IIS WMI class? - Hi there, I am using a script to check the SMTP queue length of IIS, by using the WMI class Win32_PerfRawData_SMTPSVC_SMTPServer. On Windows 2000 this script is working fine but on Windows 2003 it's not working. After some research I found out that the....

Class not registered error - When I try to look at the localhost sight, I get this: Server Application Error The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please..

XP - IIS - Class does not exist error - HI I am running windows XP pro. IIS 5.1. I have a few websites running - just regular asp hitting access databases. When I try to get to any of the websites I get this error message: "Class does not exist" www.CoryandHayley.com ..
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]