Re: SQL Server for Oracle DBAs
From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Sun, 25 May 2008 09:39:19 +0100
Message-ID: <g1b8ns$oi5$1$8302bc10@news.demon.co.uk>
Date: Sun, 25 May 2008 09:39:19 +0100
Message-ID: <g1b8ns$oi5$1$8302bc10@news.demon.co.uk>
Whatever you do, don't try and apply Oracle theory and practices against a
SQL Server install - the two products are very very different and have very
different strategies for dealing with performance and scalability; take
one - I believe in ORacle the recommend practice is to create one RAID 10
array and plonk the data on that; in SQL Server we don't do it that way - we
put the logs on their own mirrored pair; we put the data on it's own RAID 10
array etc...
Tony.
-- Tony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson [Ramblings from the field from a SQL consultant] http://sqlserverfaq.com [UK SQL User Community] "NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:4agb345d2fuc7mk9ekub3vns0vahrbvcli_at_4ax.com...Received on Sun May 25 2008 - 03:39:19 CDT
> Anyone can recommend some links, some books?
>
> We support about two dozen Oracle dbs, and seems like we'll be getting
> a few SQL Servers to look into, and are just not read to hire a SQL
> DBA yet, but we'll look into outsourcing some stuff initially (and
> learn along).
>
> Thanks
> .......
> We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
> We use RMAN and remote catalog for backups