RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 13 Jun 2006 16:18:51 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B02CA283@W03856.li01r1d.lais.net>

> It scales linearly.

How is that?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Sent: 13. júní 2006 16:14
To: Oracle-L_at_freelists.org
Subject: RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

>>>

>>>I attended a presentation yesterday on SQL2005. They claimed to have
>>>instituted a locking mechanism similar to Oracle's.

they have. SQL2005 also supports scalable shared databases. on a polyserve cluster you can have one database in the SAN (CFS) mounted on up to 16 servers, run reports or ad hoc queries, ETL, etc concurrently and then scale back to since server read/write mode. It scales linearly. This is not parallel execution, but concurrent. And transforming from read/write OLTP mode to 16 node scaled out mode is a simple command, takes 30 seconds and there are no volume mount/unmount operations to do it.

It isn't Sybase Cougar, but hey, at least it is a cousin.

If anyone wants the paper, let me know.

--
http://www.freelists.org/webpage/oracle-l


Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 13 2006 - 11:18:51 CDT