MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
If and When (clustering) - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

If and When (clustering)

Last post 08-05-2008 12:52 AM by Charley Hanania. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-18-2008 8:28 AM

    If and When (clustering)

    In the next link,    http://www.mssqltips.com/tip.asp?tip=1541 , there is a paragraph

    where it mentions that clustering in SQL server is about availability, opposite about

    others setups about incresasing power processing;

    Is there something about it (clusters for add power processing) in SQL Server

    (perhaps  in the incoming SQL 2008?) ?

    Thanks 

     

    Filed under: ,
  • 08-05-2008 12:52 AM In reply to

    Re: If and When (clustering)

    Hi Maac2002,

    MS have the High Performance Computing (HPC) initiative, which allows for transparent scale out of applications and services. This does not transcend into the SQL Server space, but scale out for performance can be looked at using technologies such as Peer to Peer Replication or distributing the database work over several servers using Distributed Partitioned Views. ORACLE has RAC to attempt to do this seemslessly to the database connections, allowing in process failover as well, but ORACLE's implementation doesn't have a 1:1 mapping into MS SQL Server.

    BTW: Good information on Scaling out SQL Server: MSDN: Scaling Out SQL Server 2005

    Hope this helps.

    Charley Hanania
    B.Sc (Computing Science), MCP, MCDBA, MCITP, MCTS, MCT
Page 1 of 1 (2 items)