Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Scaling-out SqlServer? Is it possibile ?

 
   Database Forums (Home) -> Clustering RSS
Next:  change partition's data source programmaticly  
Author Message
ernest

External


Since: Nov 26, 2007
Posts: 1



(Msg. 1) Posted: Mon Nov 26, 2007 1:58 pm
Post subject: Scaling-out SqlServer? Is it possibile ?
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

Hello everybody !

I hope this is the right place for my questions.

I would like to know whether there is a possibility to make available the
same data on two(or more) different instances of the database server, each
instance installed on a different computer.

Thank you very much !
Ernest

 >> Stay informed about: Scaling-out SqlServer? Is it possibile ? 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 2) Posted: Mon Nov 26, 2007 1:58 pm
Post subject: Re: Scaling-out SqlServer? Is it possibile ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There is no native SQL Server multi-host, single-data-set scale out
technology.

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


"ernest" wrote in message

> Hello everybody !
>
> I hope this is the right place for my questions.
>
> I would like to know whether there is a possibility to make available the
> same data on two(or more) different instances of the database server, each
> instance installed on a different computer.
>
> Thank you very much !
> Ernest
>
>
>

 >> Stay informed about: Scaling-out SqlServer? Is it possibile ? 
Back to top
Login to vote
Rick Heiges

External


Since: Oct 10, 2007
Posts: 3



(Msg. 3) Posted: Mon Nov 26, 2007 7:35 pm
Post subject: Re: Scaling-out SqlServer? Is it possibile ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There is a technology available in SQL Server 2005 called Scalable Shared
Databases. However, I have not heard of anyone implementing this technology
yet and it is read-only. Basically, you copy your data to a SAN volume,
mark that volume as read-only, and attach it to multiple servers. Check out
this article for more info. http://support.microsoft.com/kb/910378

Other than that, if you have more control over your application and
database, Peer-to-Peer Replication is about as close as you are going to
get. This is not an "Add-on" technology though and the application
architecture must support it.

Hope this helps!

Rick Heiges
SQL Server MVP

"ernest" wrote in message

> Hello everybody !
>
> I hope this is the right place for my questions.
>
> I would like to know whether there is a possibility to make available the
> same data on two(or more) different instances of the database server, each
> instance installed on a different computer.
>
> Thank you very much !
> Ernest
>
>
>
 >> Stay informed about: Scaling-out SqlServer? Is it possibile ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Scaling Out - the Future - You guys just posted that there is no true Scale Out technology with SS. But I am curious: does MS have anything in the works? Are there any rumors? I'm wondering because I get Unix and Oracle guys constantly telling me that Windows can't scale out...

Cluster active/active SQLServer/SSAS - Hi, I'd like to know how I can setup a Windows cluster with one node for SQL Server and one node for Analysis Services ? Please advise ? many thanks for your answers -- TH

Enterprise Manger against remote cluster - Newbe question; how to connect to a remote cluster over VPN (Cisco) with Enterprise Manager (EM)? Client connectivity installed locally and failover cluster running remote with Cisco software VPN-client between. I successfully registered the server....

SQL Reporting Service on Cluster server - Hi, If I install SQL RS Enterprise on SQL Cluster , do I have to create IIS Cluster Resource for the "Reports" and "Report Server " web virtual directory ? Norman

SQL Cluster 5005 (0000138d) - I reinstalled second node after a hardware failure. I followed the instruction on "How to add nodes to an existing virtual server". When I try to move group the message "5005 (0000138d)" coming up.
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]