sql-server-2008iiswindows-server-2012mssqlft

Maximize Microsoft Web and Database with 2 servers


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.


Solution

  • 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