Re: SQL Server for Oracle DBAs
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 29 May 2008 14:19:19 -0700
Message-ID: <1212095970.533275@bubbleator.drizzle.com>
>
> You have your knowledge as demonstrated on the Oracle engine - I
> sincerely hope you don't try and apply that knowledge to SQL Server.
>
> You need to understand how SQL Server works and not blindly adopt the
> belief that works for Oracle will work for SQL Server - it doesn't.
>
> On an additional note; SQL Server has cache, it has LRU and other
> algolrthyms to deal with what is kept in cache, we have read ahead reads
> to improve getting large chunks of data off disk. SQL Server only writes
> the log immediately, the data (dirty pages) (MDF / NDF) files are
> written lazyly and batched up to get them on disk more efficiently.
>
> My ideaology may suck for the oracle engine but that wasn't the OP's
> question, the OP "Anyone can recommend some links, some books?" for SQL
> Server and I made the valid comment which frankly still stands....
>
>
> So Joel, as one of the people in the ORacle forums I actually respect do
> you not think that apply oracle ideaology to SQL Server is a good idea?
> Or, is it not better to do like I stated and don't try and apply oracle
> theory - instead make sure you understand how the SQL Server engine
> works which is where David's link comes in.
Date: Thu, 29 May 2008 14:19:19 -0700
Message-ID: <1212095970.533275@bubbleator.drizzle.com>
Tony Rogerson wrote:
> Which all goes back to my previous point that I got flamed about....
>
>> 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
>
> You have your knowledge as demonstrated on the Oracle engine - I
> sincerely hope you don't try and apply that knowledge to SQL Server.
>
> You need to understand how SQL Server works and not blindly adopt the
> belief that works for Oracle will work for SQL Server - it doesn't.
>
> On an additional note; SQL Server has cache, it has LRU and other
> algolrthyms to deal with what is kept in cache, we have read ahead reads
> to improve getting large chunks of data off disk. SQL Server only writes
> the log immediately, the data (dirty pages) (MDF / NDF) files are
> written lazyly and batched up to get them on disk more efficiently.
>
> My ideaology may suck for the oracle engine but that wasn't the OP's
> question, the OP "Anyone can recommend some links, some books?" for SQL
> Server and I made the valid comment which frankly still stands....
>
>> 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
>
> So Joel, as one of the people in the ORacle forums I actually respect do
> you not think that apply oracle ideaology to SQL Server is a good idea?
> Or, is it not better to do like I stated and don't try and apply oracle
> theory - instead make sure you understand how the SQL Server engine
> works which is where David's link comes in.
Repeatedly in this forum the point has been made, by myself and others, that the underlying concepts that separate Oracle and SQL Server are quite different. Tom Kyte wrote extensively about this in his One on One Oracle book years ago. You are lecturing the choir.
Glad to know you are finally hearing the music.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu May 29 2008 - 16:19:19 CDT