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 ?
>> >
>> >
>> >

Does Interactive Sort works with Snapshots and Cached Reports?

I have created reports in RS 2005 using interactive sort on some columns.
When the reports are rendered real time, the sort works perfectly. When the
execution is changed to Snapshot, the sorting no longer works. When the
execution is set to Cached, the sort works the first time the report is
viewed, but not in subsequent viewings.
If this is a known bug, I'll give up on including this feature in my
reports. Can anyone confirm if this is supposed to work in RTM or SP1, or if
it's still on the bug list?
Thanks.I have this exact problem in designer mode with Visual 2005!
I have no clue what is going on - at times with RS2005 - was so stable with
2000 - now I am getting frustrated!
"Denise" wrote:
> I have created reports in RS 2005 using interactive sort on some columns.
> When the reports are rendered real time, the sort works perfectly. When the
> execution is changed to Snapshot, the sorting no longer works. When the
> execution is set to Cached, the sort works the first time the report is
> viewed, but not in subsequent viewings.
> If this is a known bug, I'll give up on including this feature in my
> reports. Can anyone confirm if this is supposed to work in RTM or SP1, or if
> it's still on the bug list?
> Thanks.