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 |
|
rlaubert
Yak Posting Veteran
96 Posts |
 Posted - 2008-05-09 : 15:31:16
|
| This is bad, what I thought I knew about clustering I now am questioning as I research this more.When I have a multi server (say 4 servers) cluster using Windows 2003 & SQL 2005 Enterprise editions, can they or can they not all access the same resource database? If not, then I need to know how to provide better service to a web app that is heavy on the database access. We have a load balanced front end (web services) but the current SQL Server is now becoming a bottleneck and need to start to spread the workload across multiple sql servers access the same database in real time. Data is not currently partitioned. Regardless of the arrangement I will need to maintain the cluster for failover, but also need to spread the workload.ThanksRaymond LaubertMCITP:Administration, MCThttp://www.rd-webhosting.comHome Based Business Library and Hosting |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-09 : 15:45:22
|
| Microsoft clustering is not a load balancer. You can not have multiple nodes accessing the same SQL instance and therefore the same database. That is not the purpose of clustering. You can spread the workload by using partitioned views across multiple instances. Those instances can be spread across nodes/servers.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-05-13 : 03:43:59
|
| I recently read peer-to-peer replication, might be of interest to you--------------------keeping it simple... |
|
|
|
|
|
|
Feeling stupid...SQL Cluster Question