Chapter 7. Troubleshooting Memory Issues

SQL Server is a memory-intensive application: it can consume hundreds of gigabytes or even terabytes of memory. This is completely normal and often a good thing – using this much memory reduces the need for physical I/O and recompilations, improving server performance.

In this chapter, I will discuss how SQL Server works with memory. I will start with an overview of how SQL Server uses memory and give you a few tips on memory configuration. Next, I’ll discuss the memory allocation process and show you how to analyze the memory usage of internal SQL Server components. Then I’ll talk about query memory grants and the ways to troubleshoot extensive query memory usage. Finally, I’ll briefly discuss memory management and potential issues in In-Memory OLTP implementation.

SQL Server Memory Usage and Configuration

By default, SQL Server tries to allocate as much memory as possible if ...

Get SQL Server Advanced Troubleshooting and Performance Tuning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.