O'Reilly logo

SQL Server 2005 Practical Troubleshooting: The Database Engine by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Memory Issues

By Slava Oks

Introduction to Windows Memory Management

In this section, I will briefly describe how the Windows memory manager works. These concepts are key to understanding how SQLOS and SQL Server manage memory. We will talk about the key aspects of the Windows virtual and physical memory management, as well as features that enable high-end servers—such as SQL Server—fine-grain control over their memory usage.

We look at memory as a set of common resources shared by applications, their components, and operating system. It is important to be very specific when talking about memory. In many cases, developers, users, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required