I need a best technique to boost the performance and availability for the web and database server. My problem is I only can afford two 2 dedicated servers total.
I like to take a full advantage of the two servers by installing the NBL to help the IIS to distribute the traffic. I believe I will have a problem with the MS SQL 2008 Standard edition with Failover option.
My question is: Does the NBL cause conflicts with the SQL 2008 Standard with the Failover and doesn't my settings below causing any conflict with the database settings.
Server settings are:
Server 1 - SQL 2008 R2 Standard Edition with NBL installed, IIS, SQL Standard with Failover
Server 2 - SQL 2008 R2 Standard Edition with NBL installed, IIS, SQL Standard with Failover.
I believe I have to remove the NBL to work the server work property, this is a waste of resource. I understood that the SQL 2008 Standard do not support scale-out feature. Moving from standard to enterprise edition would be too expensive.
MS SQL Standard Failover option will not work on the MS Windows Server Standard version, only the enterprise and datacenter editions can support the failover. Ref: http://technet.microsoft.com/en-us/library/cc770625%28v=ws.10%29.aspx