Re: How can i cluster sql 2005 for load balancing?
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Mon, 6 Nov 2006 23:37:14 -0800
As Tom mentioned, look in Books Online for "Distributed Partitioned Views".
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"abssoft2000" <abssoft2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A1D3E5D7-2077-443D-9F6E-D6056A4BCA83@xxxxxxxxxxxxxxxx
i think it is not difficult. i want to distribute my big table between many
servers(include CPU,Ram,Disks) not one server.
i want to use a method that is is distributable. for example: when my
table
being larger i could add some new servers to my system to increase my
performance without changing current servers.
note: i only want increase my performance only by add a complete new
servers
(include CPU,Ram,...) to currenct system
"Tom Moreau" wrote:
Well, without seeing your entire system, that would be difficult.
If you have a disk I/O bottleneck, it could be that you're memory
starved.
It could also be that your RAID array has very few spindles.
What numbers have you been getting from Perf Mon?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"abssoft2000" <abssoft2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D066863B-BAB8-48CE-8D1B-C3BBC451E505@xxxxxxxxxxxxxxxx
Table partitioning 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,...).
"Tom Moreau" wrote:
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.
.
- References:
- Re: How can i cluster sql 2005 for load balancing?
- From: Tom Moreau
- Re: How can i cluster sql 2005 for load balancing?
- From: Tom Moreau
- Re: How can i cluster sql 2005 for load balancing?
- From: abssoft2000
- Re: How can i cluster sql 2005 for load balancing?
- Prev by Date: Re: How can i cluster sql 2005 for load balancing?
- Next by Date: Re: How can i cluster sql 2005 for load balancing?
- Previous by thread: Re: How can i cluster sql 2005 for load balancing?
- Next by thread: Re: How can i cluster sql 2005 for load balancing?
- Index(es):
Relevant Pages
|
