SQL Server Architecture

  • Does any body have any docs explaining the architecture of sql server (except bol)

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • chandramohann (1/20/2009)


    Does any body have any docs explaining the architecture of sql server (except bol)

    MSDN IS THE BEST in this regard

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • What, specifically, are you looking for?

    If you want info on the storage engine, Inside SQL Server 2005: The Storage Engine is full of information. There's some stuff on the query processor and query optimiser in the the other three books of the series. The optimiser mainly in the last one Query Tuning and Optimisation

    If you can wait a bit, there's a massive tome coming out in November. SQL Server 2008 Internals, written by some fantastic people.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • One place I've been visiting for bits and pieces is this blog: http://blogs.msdn.com/sqltips/default.aspx

    But by & large, for focused information, Gail has given you what I've been using.

    There is also the SQL CAT Team blog: http://sqlcat.com/[/url]

    And the Storage Engine Blog: http://blogs.msdn.com/sqlserverstorageengine/default.aspx

    But these usually only give you snippets and drill-downs on specific topics.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • You forgot one. http://www.sqlskills.com/blogs/paul/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I didn't have that one on my list. I do now.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply