Google Answers Logo
View Question
 
Q: How can i cluster sql 2005 for load balancing? ( No Answer,   4 Comments )
Question  
Subject: How can i cluster sql 2005 for load balancing?
Category: Computers > Software
Asked by: phtco-ga
List Price: $2.00
Posted: 05 Nov 2006 22:49 PST
Expires: 29 Nov 2006 22:04 PST
Question ID: 780425
i have a table with 10,000,000,000 records and i need Select and Insert many 
records from or into this table in less than one second.
i can't buy a very expensive hardware(Server) for this SQL Server 2005
but i can buy many medium price hardwares(Servers) for this SQL Server
2005.
how can i distribute or cluster this table between many hardwares(Servers)?
note: i have few users (maximum 5 users) for my database but i have a
very large table and Sql server 2005 server need to respond to this
users in less than 1 second.
i want to distribute this huge table in seperated hardwares. becuase i
can't buy a very expensive hardware from my server but i can buy many
medium price hardware for my server.
note: i need this: when a user run a select query on this huge table
his/her request distribute between many hardwares not one hardware.
Answer  
There is no answer at this time.

Comments  
Subject: Re: How can i cluster sql 2005 for load balancing?
From: vballguy-ga on 06 Nov 2006 11:18 PST
 
You should talk to your hardware vendor - if you are ready to buy
multiple servers and talking about tables with billions of records -
you should be able to get professional advice about your
implementation...

If you are doing a homework problem - the answer might lie in
splitting the data up across servers and then routing requests...
Subject: Re: How can i cluster sql 2005 for load balancing?
From: phtco-ga on 06 Nov 2006 12:52 PST
 
i have one table but i must buy multiple servers
Subject: Re: How can i cluster sql 2005 for load balancing?
From: phtco-ga on 06 Nov 2006 14:17 PST
 
i need a method like partitioned tables in SQL 2005 but Table
partitioning only allows me to spread the load across disks. However,
all data will still be managed by a single server. my performance
bottleneck is not only Disks resources but also CPU or memory, this
method can resolve my Disk Performance bottleneck but it can't resolve
my CPU or memory Performance bottleneck.
please help me to find a solution for all resource include (CPU,Ram,Disk,...).
Subject: Re: How can i cluster sql 2005 for load balancing?
From: phtco-ga on 06 Nov 2006 22:35 PST
 
i need a method that it is distributable(like partitioned tables).
for example: when my Big table being larger i could simply add some
new servers to my system to increase performance.
note: i only want increase my performance only by add a complete new
servers (include CPU,Ram,...) to currenct system.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy