Deploying .NET web app with SQL Server database

I'm looking for some advice on deploying a new ASPX web application
I'm developing. I have two similar Win2000 servers and plan to deploy
SQL Server 2000 on one machine and IIS 5 (with .Net 1.1) on the other.

One server is a dual P3 733 and the other is a dual P3 1G, but they
are otherwise identical. Although this gear is a bit old now, it's the
best I can afford for the moment and I doubt that the system will need
to handle more then a dozen simultaneous connections.

Would I be better deploying the web server or the database on the
faster machine?

I've also got an extra 512 MB ECC RAM. Which installation would
benefit most?

Also, both machines have dual NIC's and I was thinking of connecting
the HTTP and SQL servers directly with a crossover Cat5 cable,
allowing only TCP port 1433 between them, effectively isolating the
SQL server to everything but ODBC traffic from the web server. Is this
good design?

Thanks

Install SQL on the fastest hard drives, and the most memory. As far as using a crossover cable, that is a good idea; no network
devices to go through, and this will improve perf, but it may not be noticable if load is not heavy.

Thank you. I hope this information is helpful.

Tim Coffey [MSFT]

This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft
Corporation. All rights reserved.
--------------------
| From: jsausten RemoveThis @hotmail.com (Stephen Miller)
| Newsgroups: microsoft.public.sqlserver.server,microsoft.public.dotnet.framework.setup,microsoft.public.inetserver.iis
| Subject: Deploying .NET web app with SQL Server database
| Date: 14 Sep 2003 03:07:14 -0700
| Organization: http://groups.google.com/
| Lines: 22
| Message-ID: <cdb404de.0309140207.4230ef4b RemoveThis @posting.google.com>
| NNTP-Posting-Host: 144.137.200.161
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1063534036 2818 127.0.0.1 (14 Sep 2003 10:07:16 GMT)
| X-Complaints-To: groups-abuse RemoveThis @google.com
| NNTP-Posting-Date: 14 Sep 2003 10:07:16 GMT
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.com!prodigy.com!pd2nf1so.cg.shawcable.net!
residential.shaw.ca!sn-xit-03!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.setup:5546 microsoft.public.inetserver.iis:275441
microsoft.public.sqlserver.server:306305
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
| I'm looking for some advice on deploying a new ASPX web application
| I'm developing. I have two similar Win2000 servers and plan to deploy
| SQL Server 2000 on one machine and IIS 5 (with .Net 1.1) on the other.
|
| One server is a dual P3 733 and the other is a dual P3 1G, but they
| are otherwise identical. Although this gear is a bit old now, it's the
| best I can afford for the moment and I doubt that the system will need
| to handle more then a dozen simultaneous connections.
|
| Would I be better deploying the web server or the database on the
| faster machine?
|
| I've also got an extra 512 MB ECC RAM. Which installation would
| benefit most?
|
| Also, both machines have dual NIC's and I was thinking of connecting
| the HTTP and SQL servers directly with a crossover Cat5 cable,
| allowing only TCP port 1433 between them, effectively isolating the
| SQL server to everything but ODBC traffic from the web server. Is this
| good design?
|
| Thanks
|