December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
SQL Server Instance Architecture
Figure 36.1 illustrates the address space architecture of an instance of SQL Server 2012. When you fire up a SQL Server instance, two main areas are allocated: the code area and memory pool area. The code area is mostly static executable code of the SQL Server kernel; SQL Server .NET Library DLLs; Open Data Services code; the stack space; and a variable code area that contains distributed query OLE DB providers, OLE automation objects, and extended stored procedures as they are needed by user requests.
FIGURE 36.1 The SQL Server 2012 instance architecture.
The memory pool area of SQL Server is the most dynamically ...