Inside SQL Server 2000's Memory Management Facilities

By Bill Graziano on 29 January 2004 | Tags: Memory Tuning


In this column, we'll explore the internals of SQL Server memory management from a developer's perspective. That is, we'll discuss the way the server manages memory in terms of the APIs and operating system facilities it makes use of and how they work. Exploring a product in this fashion helps us get inside the heads of the developers who built it and helps us understand how they intended it to be used. Understanding how a product works internally and its intended use is key to mastering it.

We'll begin our investigation by first covering some basic Windows® memory management fundamentals. Like all 32-bit Windows applications, SQL Server makes use of Windows memory management facilities to allocate, free, and generally manage memory resources. It calls Win32® memory management API functions to interact with the memory resources provided by the operating system in the same way that any Windows application does.

Link: Inside SQL Server 2000's Memory Management Facilities


Related Articles

What Query Plans are in SQL Server's Memory? (25 July 2007)

What Data is in SQL Server's Memory? (23 July 2007)

HOW TO: Configure Memory for More Than 2 GB in SQL Server (Q274750) (10 June 2002)

Configure Memory for More Than 2 GB in SQL Server (8 April 2002)

Other Recent Forum Posts

Checkmark for guaranteed SR = WR (11h)

How to connect to git in SQL Server 2016/2017 without using any third party tool (11h)

Sql restart (17h)

Excel column wise data save in rows (1d)

Date timzone conversion (2d)

Object cannot be cast from DBNULL to other types coming randomly in SSIS Package-Migrated from VS 2008 to 2015,SQL 2008R2 to SQL2016 on 1st run only (2d)

Error in sp procedure- Msg 50000, Level 16, State 1, Procedure spCheckDBInfo, Line 193 [Batch Start Line 0 (2d)

Two records into a single record? (2d)

- Advertisement -