Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Microsoft MS SQL article for Oracle Professionals

RE: Microsoft MS SQL article for Oracle Professionals

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 18 Oct 2005 07:43:51 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FD03@EXCNYSM0A1AJ.nysemail.nyenet>


It is a strange article. It started out rather fairly comparing the two databases - how they are similar and how they are different. When the article hit "backups", it completely skipped describing Oracle backups - like the author either didn't know or just got tired.  

I wonder who this was written for?  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, October 18, 2005 3:02 AM
To: Oracle-L Freelists
Subject: Microsoft MS SQL article for Oracle Professionals  

The following article appeared in the DBA Village newsletter.

Anyone else see it?

There's no way to comment directly on the article there, so I'm taking a whack at it here.

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.ms px

I took a look at one paragraph, the one under the heading 'Striping Data'.

> Oracle-type segments are not needed for most Microsoft SQL Server
installations.

What, SQL Server doesn't use tables or indexes?

> Instead, SQL Server can distribute, or stripe, data more efficiently
with hardware-based RAID ...

Still doesn't have much to do with a segment.

> The recommended RAID configuration for SQL Server is RAID 1
(mirroring) or RAID 5
> (stripe sets with an extra parity drive, for redundancy).
> RAID 10 (mirroring of striped sets with parity) is also recommended,
but is much more
> expensive than the first two options.

Hmm...

Should I buy 10 disks for that 5x2 RAID10 volume?

Or should I just buy 10 disks and settle for 5 RAID1 volumes?

>If RAID is not an option, filegroups are an attractive alternative and
> provide some of the same benefits available with RAID. Additionally,
> for very large databases that might span multiple physical RAID
arrays,
> filegroups may be an attractive way to further distribute your I/O
> across RAID arrays in a controlled fashion.

Sounds a bit like a tablespace.
Which is what the article was attempting to SQL Server didn't need in the earlier comments about segments.

'nuff fun for one evening.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2005 - 06:46:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US