SQL Server at the system level

  • I'm looking for some information about SQL Server at the system level. Some examples:

    memory utilization/management

    OS interaction

    CPU utilization

    I/O

    Does anyone have links to some good content that will explain to me what SQL Server is doing at the system level? I've googled around but don't get any real meat and potatoes.

    TIA.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • I guess I'm not sure what you're asking for. Are you asking about the internal workings of the engine (memory addressing, I/O requests, etc.), or about performance characteristics (baseline CPU use, etc.), or something else?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • If I understand the question, the best resource I know for this is Kalen Delaney's book: Inside SQL Server 2008: The Storage Engine. Absolutely fantastic.

    "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

  • Thanks for the replies.

    G, I'd like to know a little more about both of those sections.

    I've seen excerpts of Kalen's book (it does look excellent), but does it relate to SQL Server 2005?

    Here's some examples of what I'd like to clarify/expand my knowledge of:

    "Well it's the way that SQL Server is built, essentially. That is, it was designed to really take over as much of the box as possible. For example, it puts itself into a mode, where it basically will work with the memory directly, and also will schedule threads to be run on the CPUs the way that it wants it to. So it doesn't really pass that off to the operating system to do, because it wants to do it. It wants to take over as much of the box as possible, and that's very different from a lot of other applications that have been successfully virtualized."

    "SQL Server will take all memory that is allocated to it (it doesn't share nicely)."

    Those are just a couple of quotes from various articles.

    I realize this is a big topic, was hoping someone could point me to a blog or article or two that would get me going in some sort of direction.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • Dan H. (12/4/2009)


    I've seen excerpts of Kalen's book (it does look excellent), but does it relate to SQL Server 2005?

    The title's actually Inside SQL Server 2005: The Storage Engine. There isn't a 2008 version (well, SQL 2008 internals could be considered the 2008 version++)

    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
  • Definitely start with the book. Anything else will mostly be an expansion on that.

    Books Online has some details (or MSDN), too.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • GilaMonster (12/4/2009)


    Dan H. (12/4/2009)


    I've seen excerpts of Kalen's book (it does look excellent), but does it relate to SQL Server 2005?

    The title's actually Inside SQL Server 2005: The Storage Engine. There isn't a 2008 version (well, SQL 2008 internals could be considered the 2008 version++)

    Oops. I'm looking at the book as I type and I still get it wrong.

    "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 7 posts - 1 through 6 (of 6 total)

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