Hi All,
this is my current setup. i hv a SQL 2000 on a Windows Cluster (active - active) serving my application. I need to scale out. Is it possible to add one more set of SQL 2000 Windows Cluster and NLB them both. Is this possible. Any pointers appreciated. i searched on google but i couldnt find any

Thanks for ur help
-B

You can use NLBS to load-balance users between multiple SQL Servers on the same network, but how are you
planning to keep the data on the various SQL Servers in synch?

What is your application/number of users, that you think you need to scale-out?

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index....partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

This is three tier app with aspx pages. c# components and SQL. The number of webusers would be around 1 million and db size is around 4 GB. Majority of db is transaction db. unfortunately i am unable to give more details of this app

Yaa keeping the data in sync is one of the issues i am aware of. i hoped someone would figured it out. the db consists of file/filegroups. Thats how i am able to use active - active cluster. One other option i am thinking is create one more cluster and move some of the files to this cluster and keep the rest in the same cluster.

NLBS to load balance users, do u mean web users or sql users. If its SQL users, can u send me some pointers pl

Thanks for ur response
-

----- Neil Pike wrote: ----

You can use NLBS to load-balance users between multiple SQL Servers on the same network, but how are you
planning to keep the data on the various SQL Servers in synch

What is your application/number of users, that you think you need to scale-out


Neil Pike MVP/MCSE. Protech Computing Lt
Reply here - no emai
SQL FAQ (484 entries) se
http://forumsb.compuserve.com/gvforu...p?SRV=MSDevApp
(faqxxx.zip in lib 7
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=80
or www.sqlserverfaq.co
or www.mssqlserver.com/fa