Re: Newbie question

Tech-Archive recommends: Speed Up your PC by fixing your registry

Nodes and instances are independent. You can assign preferred node order to any instance. You can "stack" multiple instances on multiple nodes. Remember, all instances have distinct and separate databases. No sharing.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"coady" <coady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:10265D21-8D65-4A7D-AF75-39802C366B03@xxxxxxxxxxxxxxxx
AH, That's it! Multiple SQL instances. Thank you!!

So, if there's 2 instances, I1 and I2, on node 1. There are 2 other
different instances, I3 & I4 on node 2. What would happen when node 1 failed?



"Geoff N. Hiten" wrote:

You can "spread" the workload by having multiple SQL instances. Each
instance has an independent set of databases. Ffor example, you may have
OLTP on one instance and Data Warehouse on another instance.

There is currently no native load balancing technology for SQL Server.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP



"coady" <coady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B28449D1-FD9A-4C7B-B62E-1D7249640172@xxxxxxxxxxxxxxxx
> So, for example, in a 4 node SQL cluster environment, how is the > workload
> spreaded among the 3 nodes?
>
> We are looking for something that has failover and also load balancing > for
> our environment.
>
> Thank you.
>
>
>
> "Geoff N. Hiten" wrote:
>
>> SQL Clustering is a failover technology, not a scale-out technology. >> Not
>> load balancing in SQL clustering.
>>
>> -- >> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>>
>>
>>
>> "coady" <coady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:FC2499EB-4B4E-4211-A57C-00D1704A77C3@xxxxxxxxxxxxxxxx
>> > Thank you for the quick reply.
>> > In a SQL cluster environment, let's say there's 3 nodes (node >> > A,B,C).
>> > Is
>> > it
>> > true that the application will communicate with only one node to >> > access
>> > the
>> > database? In other words, is there any load balancing?
>> >
>> > Thank you.
>> >
>> >> Here is another KB I found when I created my Cluster
>> >>
>> >> "coady" wrote:
>> >>
>> >> > Hi,
>> >> >
>> >> > Just about to set up SQL 2005 cluster. Do I need to set up >> >> > Windows
>> >> > cluster
>> >> > environment, then set up SQL 2005 cluster?
>> >> >
>> >> > Thank you
>>
>>



.

Relevant Pages

  • Re: ActiveActivepassive setup
    ... Principal SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ... Nodes are host platforms. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 Cluster install error/Group cannot be validated
    ... Geoff thanks for the information! ... My Sql database service and Analysis service install failed when I tried to ... Senior SQL Infrastructure Consultant ... different domain admin account but again the same error. ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to clustering and need some clarification on disk resource
    ... "Geoff N. Hiten" wrote: ... second node, only the primary, during a cluster install. ... Senior SQL Infrastructure Consultant ... enough disk space for all your data. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Newbie question
    ... "Geoff N. Hiten" wrote: ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ... Just about to set up SQL 2005 cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2003 cluster trust issue during install?
    ... Geoff, that was the same link I mentioned in one of my replies. ... is that after the system checks both nodes, it finds 8+ issues on NODE1, ... then MS SQL tells me it's unavailable to remove. ... How can I remove NODE1 from the SQL install if the system will ...
    (microsoft.public.sqlserver.clustering)