|
|
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. |
|
There is no answer at this time. |
|
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. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |