How can i cluster sql 2005 for load balancing?

Avatar Image
abssoft2000 | 20:20 Mon 06th Nov 2006 | Technology
3 Answers
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
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.


1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by abssoft2000. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
As far as I'm aware you can't run a single database across multiple SQL servers. A database can only run on one server at a time.
Good grief! That's nearly two records for every man, woman and child on the planet! You're not working for the CIA are you?
Maybe the zero key had a stutter.

1 to 3 of 3rss feed

Do you know the answer?

How can i cluster sql 2005 for load balancing?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.