SQL Server Performance Forum – Threads Archive
Load Distribution
Hi GurusThere is a huge burden on our Database server.How can I distribute the load in SQL Server.
Please also let me Know How can I store data files of a database in different server
in order to reduce the I/O congession.
Please let me know if you have any other solutions of distributing the load on server
to a different server of the same database. Thanks raj
What kind of burden is that the datbase server is facing?
If you want to distribute the load then you can take help of load balancing from operating system. http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog04.mspx,http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=8911&Key=Network Load Balancing (NLB) for information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
SQL Server Clustering provides little to no help in load balancing. It purpose is to provide failover technology. What exact problems are you facing and what environment are we talking about? OLTP or OLAP? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Hi The problem that I am facing is Read congestion where as write seems to be ok.
it is OLTP.there are about 20 plus users with about 40+ GB database.I have distributed the
physical files of the database accorss three hard disks. But for the most of the time users use data from one particular disc, which is why this is
causing REad congestion. Now If I wanted to store some datafiles to a different server disc, What should I do…? Please also give me links for the TWO WAY REplication.I am thinking one other solution is
two way replication and distribute the users across the servers.
Thanks. raj
Have you checked from network side about this congestion issue? http://www.windowsitpro.com/SQLServer/Article/ArticleID/8825/8825.html – 2 way replication information. Be aware the most common problem is the potential for conflicting data. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Search on my site on "replication" (Use the textbox in the upper right corner next to the date for it). The result page contains 26 links. Almost all are links back to MS pages. That should be a good start. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
I’ll throw a couple of ideas at you. If you posted this in the log shipping forum it sounds like you are considering whether maintaining a parallel copy of the DB could help reduce the read load on the production server. Also, wouldn’t a RAID-5 spread the reading across many spindles and result in faster throughput for you? Just some thoughts, not recommendations. …Ray
]]>