Inside SQL Server 2000's Memory Management Facilities

By Bill Graziano on 29 January 2004 | 0 Comments | 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. Follow the link to Inside SQL Server 2000's Memory Management Facilities...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

Problem when importing from Excel (0 Replies)

Dates from weeknumber (1 Reply)

Query Access table (2 Replies)

Update Date based on Employee (0 Replies)

Pivot Table (0 Replies)

Varchar to Numeric help (4 Replies)

Database performance very poor after a moths use (6 Replies)

Repeat records depending field value (2 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -