Re: SQL 2000 Load Balancing Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the reply Geoff. What i'm wondering then is what happens when you
reach the limits of hardware like I guess Microsoft do for their sites -
they must have multiple servers running?

Thanks again.



"Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx> wrote in message
news:%23yLYqF3ZFHA.796@xxxxxxxxxxxxxxxxxxxxxxx
> SQL Custering is a failover technlogy, not a load-balancing technology.
> The situation you describe, two servers accessing and managing the same
> database, is not possible with SQL Server 2000. Only one host node in a
> cluster owns and manages a SQL Server. Should that host node fail, the
> entire server goes over to another node.
>
> You need to determine what is the limiting factor on your system (CPU,
> memory, IO, Disk Capacity) and upgrade or replace your system accordingly.
>
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
>
> "Kate Smith" <ksmith2000@xxxxxxxxx> wrote in message
> news:uGJWsA3ZFHA.720@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello
>>
>> I have a question that I hope someone can shed some light on. We are
>> currently running a dedicated Dell 2850 SQL server box with a single
>> database on it that has become very heavily used over the last year. What
>> we'd like to do is to add another server (rather than buying higher spec
>> hardware) to load balance the SQL database. I'm aware that I will need to
>> buy some shared storage (such as a Dell PV 220s) and connect the 2
>> servers to this but will I be able to load balance the single database in
>> this situation so that half the traffic goes to one server and half to
>> the other? I've read a bit about clustering and would like to setup a
>> cluster where both nodes are accessing the same database and if one node
>> fails, the otehr will take over (albeit with a performance reduction of
>> course).
>>
>> Thanks for your help guys.
>>
>
>


.

Relevant Pages

  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
  • Re: Sharepoint question
    ... Services relies on databases to store all data for a virtual server, ... The configuration database maintains connections between servers and ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Cisco801
    ... Routing Table on the SBS 2K3 server. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... You just need to add the database IP ...
    (microsoft.public.windows.server.sbs)