load balancing in sql server database ???????????????????????????

Hi can any one explain how can we do load balancing for database ????????????

Is your question is for sql 2005? or 2008?
You can use peer to peer replication for load balancing in sql 2005 and I don't know if there is any other improvement in sql 2008....
and also check Federated database servers in BOL...

Hey M
How can you use replication for load balancing? The application can query server A or server B and the query is executed on either server. It is not load balanced.

Hi, I am working on an application. Its a SQL Server Middle Tier, that will allow Load Balancing for SQL Server. I plan to give it away for at least the first 2 load balanced servers or something. Have come quite far with, want to see if there is a real interest for something like this in the community. I have a blog for it, although sporadic [], I have updates there...
Anyhooo, here they are http://sqlserverloadblancing.blogspot.com/ (old one), http://sqlserverloadbalancing.blogspot.com/ (new one). Let me know if people are still interested, so I can get some motivation and speed things up a bit.
Thanks,
Raj.

You may alrady know but here it is: Check out this URL for a good read:
http://www.sql-server-performance.com/articles/clustering/massive_scalability_p1.aspx
May be a bit old but it is definitely worth reading( by Doug Kerwin in 2003)
especially page 2 under "Database Load Balancing"
JasonL (from MSFT) http://blogs.msdn.com/usisvde/

Hi Satya, Sorry it took this long... I was preparing the website to host the download and other relevant information. I am still updating the documents in the "concept" section for better understanding. But anyway, here it is [] http://www.poorstudent.org. The application (rather 1 dll and a readme file zipped up) is in there as well as how to install it and setup the middle tier and stuff.
Please let me know if this explains what I was talking about?
Thanks,
Raj

Thanks, Yep... Thats the next step, I am trying to find someone to do this for me.
Does the concept for "Distributed SQL Server Load Balancing" make sense though?

I am very interested in this and I am ready to implement now. Let me know how I may assist you

Awesome thanks []... Send me an email at raj@poorstudent.org. Although all instructions can be found at poorstudent.org; I would rather, we walk through it together and I can explain the things that I forgot to add/ doesn't make sense.
High level: just need a website that makes multiple calls to databases. The goal is to intercept the calls, and use "SQL Server Distributed Load Balancing", to distribute the calls to multiple database servers. The servers maybe be virtual or physical, geographically separated or not. Basically whatever is available, as long as they are separated by their WINS/DNS entries.
Thanks, Raj

Hi Guys,
As per my understanding only through Peer to Peer replication you can do the load balancing in SQL server 2005 and 2008, but here you need to use Windows load balancing tool (I am not sure but you need to use NLB with your web server) and it’s up to NLB algorithms which server it will redirect your query. Here I want to mention one more complexity about peer to peer replication, if it’s break anytime it’s very tough to resume replication. Most of the time you need to restore database backup from one node to another node and need to configure complete Peer to Peer Replication once again. There is no doubt you lose some data.
Regards,

Nandan Pandey

Hi Guys,
I joined newly to this forum & thought to share my view of DB load balancing
Is it possible to have all write operation on a DB & Load balance read operations from a farm of replicated DB servers? Just a thought. It may be possible that many of them might also be using this architecture.