August 6, 2004 at 11:38 am
Currently we use transactional replication to push data from a OLTP server to a single reporting server (both using Sql Server 2k Ent Edit). I want to add another subscriber to the replication topology so that 2 db servers are able to handle the reporting requests.
Our reports are written in ASP.Net and we use IIS 6. We also are using Reporting Services on another server. I would like the IIS server and the Reporting Services to utilize the 2 db servers equally. Ideally I would like to put a load balancer between the 2 reporting servers and the 2 db servers but budget contraints prohibit that. Is it possible to use the Windows 2003 network load balancing service on the 2 db servers so that data requests comming from the 2 reporting servers are split across the 2 db servers?
Thanks
August 8, 2004 at 12:21 am
I am not sure w2003 loadbalancing is meant to works with sql servers.
What you can do is :
1 - Make the 2 db servers are identical in schema and data
2 - Run win2003 network loadbalancing on the 2 IIS machines and make IIS 1 point to DB 1 while IIS 2 points to DB 2
August 8, 2004 at 8:08 pm
SQL Server does not support network load balancing. Yukon also does not have this feature. I think we might have to wait for the next product release.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply