Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2003-06-24 : 21:56:55
|
| I know a little bit about SQL Server clustering and do know that it is not intended for load balancing, and does not perform such a service. I have two questions. First, where can I get some good concise information on clustering, and running clusterd servers? My second question is, how do I distribute the load on a heavily used database? Is there a way to do it? Any info, articles, or books you guys can point me to would be most appreciated.Thanks,Steve |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-06-25 : 02:35:23
|
| You can download the High Availability series in PDF format[url]http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/confeat/sqlha/SQLHALP.asp[/url]also have a look at [url]http://www.sql-server-performance.com/clustering_2000.asp[/url][url]http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/reskit/sql2000/part4/c1261.asp[/url][url]http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/reskit/sql2000/part4/c1261.asp[/url][url]http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp[/url][url]http://www.microsoft.com/windows2000/techinfo/administration/cluster/domainlets.asp[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
Blastrix
Posting Yak Master
208 Posts |
Posted - 2003-06-25 : 11:02:54
|
| Thanks for the links Jasper, these all seem to mostly deal with clustering, which is of course great, but it doesn't explain much for load balancing one database for SQL Server. One of them touches on load balancing, but it's more of a general guide, or a guide for Windows load balancing. I need to know how to implement load-balancing for the SQL Server as well.If there is information on this in the articles, please let me know where, since I must have missed it.Thanks,Steve |
|
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2003-06-25 : 11:49:02
|
| one way to do this is to setup replication...you essentially can have a single server setup for the writes and the pushing of the writes to the subscribers ... then all your reading is done from a subscriber... something like that will give you a quasi load balanced environment ... you could also setup several write-caching servers that process requests to write the the db master ... |
|
|
|
|
|
|
|
|
Clustering / Load-Balancing