Re: How can i cluster sql 2005 for load balancing?

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.



.

Relevant Pages

  • Re: Choosing the proper disk setup. I need help and advice.
    ... established that inadequate disk I/O is in fact causing your performance ... inadequeate CPU speed, or network I/O as the bottleneck. ... <<Will the performance increases be worth using this configuration?>> ... which you can know that any hardware changes actually improved things. ...
    (microsoft.public.windows.server.general)
  • RE: Huge number of files in a directory
    ... I have 2 SAS disk in RAID 1. ... When we make the migration to a powerfull server, ... Quantity?...I've had problems doing an 'ls -al' on a single directory ... If you do find the number of files is a bottleneck, ...
    (RedHat)
  • Re: We quadrupled hardware power and reduced performance
    ... bottleneck, which may be CPU, Memory, Disk, but given you're on newer & ... SQL Server MVP ... > The new computer has two hardware mirrored drives, as I said, 120 GB ... > or if the large drives, not striped, would it the problem, or what... ...
    (microsoft.public.sqlserver.server)
  • Re: Server Locks Up at Exactly 4% into a Disk Sychronization
    ... It ended up being hardware. ... and the new server worked perfectly. ... second physical disk, and added it as a mirror to the first. ... mirroring drives is out side the scope of our support." ...
    (microsoft.public.windows.server.general)
  • Re: Huge number of files in a directory
    ... all the data was in a single disk without RAID. ... When we make the migration to a powerfull server, with the new disks, it took 4 days to finish all the transfer, and it was performed about 1 year ago. ... If you do find the number of files is a bottleneck, ... I have these images all together in a single directory, and there was about 4 million files in this folder. ...
    (RedHat)