IIS & SQL Server environments

[Angel]

Hi,

Right now, we have the production and development databases and ASP pages on one server. This is causing a strain on the performance,
of course.
Well, the finally, the customer agreed to get 2 less powerful servers. This is what we are planning to do with the 2 extra servers.

Server 1 : Original Server (fast)
We will only have the Production Database (NO IIS)

Server 2: New Machine23 (faster box than Server 2)
Offload IIS away from the production Database so we can allow more memory for Database processing.

Server 3: New Machine 3 (slower box we just got)
Move the entire development environment to one server (SQL Server Database + IIS with all the ASP pages)

Does this sound OK?
or should we have IIS sitting on one box (holding pages for Development and production) and the other machine just holds the
Development database.

I would like to hear other opinions/stories on different IIS & SQL Server configurations to maximize performance.

Thanx!
Angel

[tcronin]

We have a small Intranet with IIS and SQL 65 sp5a. We worked with a MS Solution provider who recommended putting it all on the same server. Our web is a mix of unsecured and SSL secured. The Box is a Dell 450 mhz, 20 gig, and 512Kram. Is your server a PDC or BDC? If so we found this will have an affect. It is now a member and life is better.


------------
Angel at 9/15/99 10:48:35 AM

Hi,

Right now, we have the production and development databases and ASP pages on one server. This is causing a strain on the performance,
of course.
Well, the finally, the customer agreed to get 2 less powerful servers. This is what we are planning to do with the 2 extra servers.

Server 1 : Original Server (fast)
We will only have the Production Database (NO IIS)

Server 2: New Machine23 (faster box than Server 2)
Offload IIS away from the production Database so we can allow more memory for Database processing.

Server 3: New Machine 3 (slower box we just got)
Move the entire development environment to one server (SQL Server Database + IIS with all the ASP pages)

Does this sound OK?
or should we have IIS sitting on one box (holding pages for Development and production) and the other machine just holds the
Development database.

I would like to hear other opinions/stories on different IIS & SQL Server configurations to maximize performance.

Thanx!
Angel