Does SQL Server (either 2005 or 2008) have some things similar to Oracle Real Application

Dear all,
Does Microsoft SQL Server (either 2005 or 2008) have some things similar to
Oracle Real Application Clusters ?
As my company's database system work load is getting heavier and heavier,
many colleagues ask me whether we can join a couple of machines as a one
logical machines for a SQL Server database.
However, I know Microsoft Clustering can only provide an Active/Passive mode
and only Oracle Real Application Cluster might fulfill what they want.
So, can you tell me will SQL Server 2005 or 2008 also has this Real
Application Clusters feature ?I believe you mean "load balancing" and SQL Server does not have a feature
like that.
SQL Server has Active\Passive and Active\Active cluster structures. Which
are not about load balancing exactly.
You may use the cluster structure named Active\Active or a better term "more
than one active node" in a meaning load balancing if you divide your
database into 2 pieces. Locate half of it on one of the nodes in the cluster
and locate the other one on the other node. Or you may want to perform OLTP
processes on the first node and replicate the database on the first node to
the second node and perform OLAP, reporting processes on the second node.
I'm not sure about SQL Server 2008.
--
Ekrem Önsoy
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:47008666$1@.127.0.0.1...
> Dear all,
> Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> to
> Oracle Real Application Clusters ?
> As my company's database system work load is getting heavier and heavier,
> many colleagues ask me whether we can join a couple of machines as a one
> logical machines for a SQL Server database.
> However, I know Microsoft Clustering can only provide an Active/Passive
> mode
> and only Oracle Real Application Cluster might fulfill what they want.
> So, can you tell me will SQL Server 2005 or 2008 also has this Real
> Application Clusters feature ?
>
>|||Thanks
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:B0D0F3D9-C4BC-44C5-A025-3437562E86B3@.microsoft.com...
> I believe you mean "load balancing" and SQL Server does not have a feature
> like that.
> SQL Server has Active\Passive and Active\Active cluster structures. Which
> are not about load balancing exactly.
> You may use the cluster structure named Active\Active or a better term
"more
> than one active node" in a meaning load balancing if you divide your
> database into 2 pieces. Locate half of it on one of the nodes in the
cluster
> and locate the other one on the other node. Or you may want to perform
OLTP
> processes on the first node and replicate the database on the first node
to
> the second node and perform OLAP, reporting processes on the second node.
> I'm not sure about SQL Server 2008.
> --
> Ekrem Önsoy
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:47008666$1@.127.0.0.1...
> > Dear all,
> >
> > Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> > to
> > Oracle Real Application Clusters ?
> >
> > As my company's database system work load is getting heavier and
heavier,
> > many colleagues ask me whether we can join a couple of machines as a one
> > logical machines for a SQL Server database.
> >
> > However, I know Microsoft Clustering can only provide an Active/Passive
> > mode
> > and only Oracle Real Application Cluster might fulfill what they want.
> >
> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
> > Application Clusters feature ?
> >
> >
> >
>|||> I'm not sure about SQL Server 2008.
SQL2008 doesn't have any native support that is similar to Oracle RAC or DB2
DPF.
Linchi
"Ekrem Ã?nsoy" wrote:
> I believe you mean "load balancing" and SQL Server does not have a feature
> like that.
> SQL Server has Active\Passive and Active\Active cluster structures. Which
> are not about load balancing exactly.
> You may use the cluster structure named Active\Active or a better term "more
> than one active node" in a meaning load balancing if you divide your
> database into 2 pieces. Locate half of it on one of the nodes in the cluster
> and locate the other one on the other node. Or you may want to perform OLTP
> processes on the first node and replicate the database on the first node to
> the second node and perform OLAP, reporting processes on the second node.
> I'm not sure about SQL Server 2008.
> --
> Ekrem nsoy
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:47008666$1@.127.0.0.1...
> > Dear all,
> >
> > Does Microsoft SQL Server (either 2005 or 2008) have some things similar
> > to
> > Oracle Real Application Clusters ?
> >
> > As my company's database system work load is getting heavier and heavier,
> > many colleagues ask me whether we can join a couple of machines as a one
> > logical machines for a SQL Server database.
> >
> > However, I know Microsoft Clustering can only provide an Active/Passive
> > mode
> > and only Oracle Real Application Cluster might fulfill what they want.
> >
> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
> > Application Clusters feature ?
> >
> >
> >
>|||Thanks for the info mate.
--
Ekrem Ã?nsoy
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:1BA00B04-8543-4ED8-ADAE-741773F05BD6@.microsoft.com...
>> I'm not sure about SQL Server 2008.
> SQL2008 doesn't have any native support that is similar to Oracle RAC or
> DB2
> DPF.
> Linchi
> "Ekrem Ã?nsoy" wrote:
>> I believe you mean "load balancing" and SQL Server does not have a
>> feature
>> like that.
>> SQL Server has Active\Passive and Active\Active cluster structures. Which
>> are not about load balancing exactly.
>> You may use the cluster structure named Active\Active or a better term
>> "more
>> than one active node" in a meaning load balancing if you divide your
>> database into 2 pieces. Locate half of it on one of the nodes in the
>> cluster
>> and locate the other one on the other node. Or you may want to perform
>> OLTP
>> processes on the first node and replicate the database on the first node
>> to
>> the second node and perform OLAP, reporting processes on the second node.
>> I'm not sure about SQL Server 2008.
>> --
>> Ekrem nsoy
>>
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:47008666$1@.127.0.0.1...
>> > Dear all,
>> >
>> > Does Microsoft SQL Server (either 2005 or 2008) have some things
>> > similar
>> > to
>> > Oracle Real Application Clusters ?
>> >
>> > As my company's database system work load is getting heavier and
>> > heavier,
>> > many colleagues ask me whether we can join a couple of machines as a
>> > one
>> > logical machines for a SQL Server database.
>> >
>> > However, I know Microsoft Clustering can only provide an Active/Passive
>> > mode
>> > and only Oracle Real Application Cluster might fulfill what they want.
>> >
>> > So, can you tell me will SQL Server 2005 or 2008 also has this Real
>> > Application Clusters feature ?
>> >
>> >
>> >