About the Book

Senior DBAs have to know more than just SQL Server - they have to know storage, memory, operating systems, and more. This book gathers everything you need to know in one place, and each chapter is written by a SQL Server expert with extensive experience.

You'll learn about topics like latching, locking, memory architecture, extended events, and more.

Chapter 2 – Memory

Author: Christian Bolton

This chapter covers Windows physical memory, virtual memory, 32 vs 64 bit systems, and SQL Server memory.

Errata

None found yet, knock on wood!

Downloads

None yet.  If there’s anything you’d like to see added here, let us know with a comment.

1 comment to Chapter 2 – Memory

  • zhengsyao
    March 26, 2010 at 9:28 pm

    On page 41, is the formular correct?

    memory_to_reserve = MemReserved + (NumThreads × Stack Size)

    I think it should be ReservedMem = memory_to_reserve + (NumThreads × Stack Size)

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">