running IIS on a two node SQL cluster

[kdubb77]

I have two servers using a shared MSA500 in a failover cluster. I am thinking about installing IIS on both nodes and then a web application on both nodes and then using Windows NLB to load balance the websites. If I have a server hardware failure and the SQL cluster fails over I will still have one instance of IIS so I'm getting load balanced web and clustered SQL. Does anyone see any issues with this. Maybe the open sessions on the IIS server that get killed when the hardware fails. Any comments or suggestions??

 

[mrdenny]

I always recommend not installing anything on the SQL Server machine(s) other than SQL Server. Installing IIS will take CPU and memory resources from SQL Server which will they start to slow down the SQL Server.

I would recommend getting a couple of small servers (HP 1xx series for example) and setting them up in a load ballanced config.

This will give you the same result, without adding additional load to the existing SQL Servers.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com