Re: How can i cluster sql 2005 for load balancing?
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Nov 2006 16:11:20 -0500
Clusters are for high availability (HA) - not load balancing. You should
look at partitioned tables (SQL 2005) or partitioned views (SQL 2000). If
your queries always include the partitioning column in the WHERE clause, you
should be able to realize a performance benefit without necessarily going to
more servers. In the event that partitioned tables, or local partitioned
views, don't do it, then distributed partitioned views -0 where you do use
multiple servers - can be the solution.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"abssoft2000" <abssoft2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0366D5B7-B160-417E-8037-5269258365FF@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Error during sql server 2000 Ent Edition on Windows 2003 clust
- Next by Date: Re: adding disk
- Previous by thread: Re: adding disk
- Next by thread: Re: How can i cluster sql 2005 for load balancing?
- Index(es):
Relevant Pages
|
Loading
