SQL Server 200* database architecture

• ArjunaReddy

  Default port

  Points: 1467

  More actions

  August 26, 2009 at 1:18 am

  #133141

  Hi SQL Gurus!

  I am basically an Oracle DBA with 4yrs of experience and have bit experience with SQL Server from past 2 years. Could any one give me brief introduction about the SQL Server architecture as oracle has? I tried googling for this with no luck.

  Thanks,

  Nagarjun.

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  August 26, 2009 at 5:05 am

  #1044771

  bommaka.nagarjun (8/26/2009)

  ---

  Hi SQL Gurus!

  I am basically an Oracle DBA with 4yrs of experience and have bit experience with SQL Server from past 2 years. Could any one give me brief introduction about the SQL Server architecture as oracle has? I tried googling for this with no luck.

  Thanks,

  Nagarjun.

  Not sure if this will help or not.

  http://www.microsoft.com/sql/prodinfo/compare/oracle/oracledba/quickguide/01_welcome/01_quotes.htm

  Generally the sqlserver site on the microsoft main site is the best place for finding resources.

  http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• dba_pkashyap

  Hall of Fame

  Points: 3336

  More actions

  August 26, 2009 at 7:01 am

  #1044808

  Its similar to Oracle, few of them as per my knowledge below:

  Oracle--Tablespaces,db-files, segments, extents, db-blocks

  SQl-Db-files, extents(8 pages),pages(8 diff types of pages, check for them)

  oracle--initial extent, next, min, max and all others

  SQL-Only mixed and uniform...If a table data is less than 8 pages then it is saved in mixed else in uniform..I page = 8192 KB/8MB

  SQL Doesnt have pfile and spfile, its all set using properties(server level/db level)

  oracle Redo logs , rollback/undo is in SQL transactional log files.

  Oracle--Data guard, SQL - Log shipping.

  SQL Indexes--Only 2 types, clustered, non-clustered.

  pavan.