model='gemma3:latest' created_at='2025-09-18T08:07:07.730130101Z' done=True done_reason='stop' total_duration=50324593819 load_duration=546811440 prompt_eval_count=156 prompt_eval_duration=79190598 eval_count=1466 eval_duration=18773849034 response='```html\n\n\n\n \n \n SQL Server Performance: Memory Tuning - Microsoft Learn\n \n \n\n\n\n

\n

SQL Server Performance: Memory Tuning

\n

Learn about memory tuning for SQL Server to improve performance.

\n

\n\n

\n

\n

Introduction

\n

Memory tuning is a critical aspect of optimizing SQL Server performance. Proper configuration ensures your database server effectively utilizes available memory, leading to faster query execution, reduced contention, and improved overall system responsiveness.

\n

\n\n

\n

Key Concepts

\n

Understanding these key concepts is essential:

\n

Memory Pools: SQL Server uses memory pools for different data structures and operations.
Buffer Manager: This component manages the caching of data pages in memory.
Page Grants: These control the amount of memory allocated to specific queries or sessions.
Memory Pressure: Excessive memory usage can lead to performance degradation.

\n

\n\n

\n

Tuning Techniques

\n

Here are some common tuning techniques:

\n

Analyze Memory Usage: Use Performance Monitor to identify memory bottlenecks.
Adjust Page Grants: Increase page grants for frequently used queries.
Optimize Database Configuration: Modify settings like max server memory.

\n

\n\n

\n

Example: Configuring Max Server Memory

\n

Setting max server memory prevents the SQL Server service from consuming more than a specific amount of RAM.

\n

-- Example command to set max server memory\n-- sp_configure \'max server memory\', 8000  -- Set to 8GB\n-- GO\n-- RECONFIGURE;\n

\n

\n\n

\n

Resources

\n

\n

\n

\n\n \n\n\n\n```' thinking=None context=[105, 2364, 107, 3048, 659, 496, 4108, 5941, 236761, 562, 2864, 815, 1164, 2229, 528, 580, 506, 2479, 965, 1356, 26223, 236786, 170534, 236786, 9275, 236772, 6458, 236772, 32677, 236786, 20624, 236772, 118291, 236761, 107, 118904, 607, 16167, 236786, 42970, 236786, 21083, 600, 563, 6780, 573, 600, 2479, 236761, 107, 16904, 994, 506, 16167, 236786, 42970, 236786, 21083, 236764, 5017, 1663, 236761, 107, 6294, 711, 3204, 1027, 8968, 653, 46119, 236761, 107, 27455, 531, 1386, 506, 4108, 3104, 618, 4148, 532, 10828, 618, 2653, 236761, 107, 8993, 236789, 236745, 4928, 600, 672, 563, 496, 16496, 236764, 1386, 625, 618, 21179, 618, 2653, 236761, 107, 3048, 740, 1138, 6658, 9851, 768, 6780, 236764, 840, 768, 506, 2430, 5238, 496, 6658, 3205, 236764, 611, 236789, 859, 735, 531, 6060, 600, 2311, 236764, 834, 577, 2889, 531, 1786, 3487, 4403, 573, 5869, 531, 3050, 1144, 611, 236789, 500, 3490, 528, 506, 10739, 236761, 106, 107, 105, 4368, 107, 2717, 3185, 107, 19174, 20526, 10523, 236813, 107, 236820, 3185, 8738, 718, 501, 905, 107, 236820, 2834, 236813, 107, 140, 236820, 7655, 19288, 718, 13052, 236772, 236828, 905, 107, 140, 236820, 7655, 1463, 718, 23609, 236775, 3004, 718, 2690, 236784, 10212, 236772, 2690, 236764, 4068, 236772, 7669, 236784, 236770, 236761, 236771, 905, 107, 140, 236820, 3250, 236813, 13886, 15335, 19791, 236787, 29179, 164042, 753, 9265, 20099, 954, 3250, 236813, 107, 140, 236820, 2883, 1151, 718, 13016, 236775, 3279, 718, 2574, 1411, 15143, 236761, 37322, 236761, 854, 236786, 501, 236772, 605, 236786, 18886, 236786, 7498, 236786, 9275, 236772, 6458, 236772, 32677, 236772, 20624, 236772, 118291, 236786, 8635, 236761, 1387, 236761, 4497, 905, 107, 140, 236820, 3061, 236813, 107, 144, 3063, 642, 107, 148, 3631, 236772, 10774, 236787, 756, 68086, 9711, 963, 110965, 236764, 38009, 236764, 91380, 236764, 7139, 236772, 10569, 236793, 107, 148, 14293, 236787, 236743, 236771, 236793, 107, 148, 13296, 236787, 236743, 236771, 236793, 107, 148, 7682, 236772, 3001, 236787, 997, 236760, 236810, 236760, 236810, 236760, 236810, 236793, 107, 148, 3001, 236787, 997, 236800, 236800, 236800, 236793, 107, 148, 1257, 236772, 4603, 236787, 236743, 236770, 236761, 236825, 236793, 107, 144, 236783, 108, 144, 5653, 642, 107, 148, 7682, 236772, 3001, 236787, 997, 236778, 236744, 236828, 236825, 236755, 236770, 236793, 107, 148, 3001, 236787, 997, 22149, 236793, 107, 148, 13296, 236787, 236743, 236778, 236771, 1885, 236793, 107, 148, 1005, 236772, 7341, 236787, 3988, 236793, 107, 144, 236783, 108, 144, 236754, 236770, 642, 107, 148, 14293, 236787, 236743, 236771, 236793, 107, 148, 3631, 236772, 2086, 236787, 236743, 236778, 236761, 236810, 581, 236793, 107, 144, 236783, 108, 144, 236761, 7498, 236772, 3955, 642, 107, 148, 13296, 236787, 236743, 236778, 236771, 1885, 236793, 107, 148, 2074, 236772, 2690, 236787, 236743, 236770, 236778, 236771, 236771, 1885, 236793, 107, 148, 14293, 236787, 236743, 236771, 6282, 236793, 107, 148, 7682, 236772, 3001, 236787, 997, 22149, 236793, 107, 148, 2566, 236772, 18184, 236787, 236743, 236771, 236743, 236771, 236743, 236770, 236771, 1885, 22952, 236769, 236771, 236764, 236743, 236771, 236764, 236743, 236771, 236764, 236743, 236771, 236761, 236770, 626, 107, 144, 236783, 108, 144, 236761, 1862, 642, 107, 148, 14293, 236772, 7571, 236787, 236743, 236800, 236771, 1885, 236793, 107, 144, 236783, 108, 144, 236761, 1862, 236772, 3250, 642, 107, 148, 3631, 236772, 2086, 236787, 236743, 236770, 236761, 236828, 581, 236793, 107, 148, 14293, 236772, 7571, 236787, 236743, 236770, 236810, 1885, 236793, 107, 148, 3001, 236787, 997, 236800, 236800, 236800, 236793, 107, 144, 236783, 108, 144, 236761, 3970, 236772, 5088, 642, 107, 148, 7682, 236772, 3001, 236787, 997, 236760, 236819, 236760, 236819, 236760, 236819, 236793, 107, 148, 13296, 236787, 236743, 236770, 236810, 1885, 236793, 107, 148, 12148, 236772, 12485, 236787, 236743, 236810, 1885, 236793, 107, 148, 3631, 236772, 10774, 236787, 756, 106316, 1799, 963, 115328, 236793, 107, 144, 236783, 108, 144, 236761, 3970, 236772, 5088, 877, 642, 107, 148, 14293, 236787, 236743, 236771, 236793, 107, 144, 236783, 108, 144, 236761, 3304, 236772, 6955, 642, 107, 148, 14293, 236772, 7571, 236787, 236743, 236778, 236771, 1885, 236793, 107, 144, 236783, 108, 144, 236761, 3304, 236772, 6955, 9291, 642, 107, 148, 2074, 236772, 2690, 236787, 236743, 236770, 236771, 236771, 8129, 107, 148, 4603, 236787, 6282, 236793, 107, 148, 12148, 236772, 12485, 236787, 236743, 236810, 1885, 236793, 107, 144, 236783, 108, 144, 14231, 642, 107, 148, 7682, 236772, 3001, 236787, 997, 236778, 236744, 236828, 236825, 236755, 236770, 236793, 107, 148, 3001, 236787, 997, 22149, 236793, 107, 148, 1005, 236772, 7341, 236787, 3988, 236793, 107, 148, 13296, 236787, 236743, 236778, 236771, 1885, 236793, 107, 148, 3631, 236772, 2086, 236787, 236743, 236771, 236761, 236828, 581, 236793, 107, 144, 236783, 108, 144, 236761, 16717, 236772, 2230, 642, 107, 148, 2690, 236787, 236743, 236770, 236771, 236771, 8129, 107, 148, 4603, 236787, 236743, 236770, 236771, 1885, 236793, 107, 148, 7682, 236772, 3001, 236787, 997, 116794, 236793, 107, 148, 12148, 236772, 12485, 236787, 236743, 236810, 1885, 236793, 107, 148, 14293, 236772, 7571, 236787, 236743, 236778, 236771, 1885, 236793, 107, 144, 236783, 108, 144, 236761, 16717, 236772, 2230, 236772, 3859, 642, 107, 148, 4603, 236787, 236743, 236770, 236771, 236771, 8129, 107, 148, 7682, 236772, 3001, 236787, 997, 236771, 236771, 236832, 236828, 236753, 236832, 236793, 107, 148, 12148, 236772, 12485, 236787, 236743, 236810, 1885, 236793, 107, 144, 236783, 108, 144, 236761, 5652, 642, 107, 148, 4971, 236787, 28265, 236772, 5088, 236793, 107, 148, 13296, 236787, 236743, 236770, 236771, 1885, 236743, 236778, 236771, 1885, 236793, 107, 148, 7682, 236772, 3001, 236787, 997, 236771, 236771, 236832, 236828, 236753, 236832, 236793, 107, 148, 3001, 236787, 997, 22149, 236793, 107, 148, 1005, 236772, 26724, 236787, 7293, 236793, 107, 148, 12148, 236772, 12485, 236787, 236743, 236810, 1885, 236793, 107, 148, 3631, 236772, 2086, 236787, 236743, 236770, 581, 236793, 107, 148, 14423, 236787, 16694, 236793, 107, 144, 236783, 108, 144, 236761, 5652, 236787, 14515, 642, 107, 148, 7682, 236772, 3001, 236787, 997, 236771, 236771, 236810, 5742, 236778, 236793, 107, 144, 236783, 108, 144, 236761, 109860, 236772, 14231, 642, 107, 148, 3473, 236787, 6530, 236793, 107, 148, 7571, 236787, 236743, 236771, 236793, 107, 148, 989, 236787, 236743, 236771, 236793, 107, 148, 2690, 236787, 236743, 236770, 236771, 236771, 8129, 107, 148, 236802, 236772, 2662, 236787, 236743, 236770, 236771, 236771, 236793, 107, 144, 236783, 107, 140, 954, 3061, 236813, 107, 954, 2834, 236813, 107, 236820, 3063, 236813, 108, 140, 236820, 5653, 236813, 107, 144, 236820, 236754, 236770, 236813, 13886, 15335, 19791, 236787, 29179, 164042, 954, 236754, 236770, 236813, 107, 144, 236820, 236758, 236813, 30354, 1003, 6571, 38738, 573, 15963, 15335, 531, 4006, 3736, 9047, 236758, 236813, 107, 140, 954, 5653, 236813, 108, 140, 236820, 1928, 1012, 718, 7498, 236772, 3955, 905, 107, 144, 236820, 1928, 1012, 718, 1862, 905, 107, 148, 236820, 1928, 1012, 718, 1862, 236772, 3250, 905, 22660, 954, 1928, 236813, 107, 148, 236820, 236758, 236813, 24365, 38738, 563, 496, 6749, 6084, 529, 61232, 15963, 15335, 3736, 236761, 70271, 9831, 22606, 822, 7948, 5941, 11974, 60432, 2487, 6571, 236764, 5830, 531, 11442, 7609, 14860, 236764, 7005, 50934, 236764, 532, 9806, 6782, 1458, 89201, 9047, 236758, 236813, 107, 144, 954, 1928, 236813, 108, 144, 236820, 1928, 1012, 718, 1862, 905, 107, 148, 236820, 1928, 1012, 718, 1862, 236772, 3250, 905, 3503, 76423, 954, 1928, 236813, 107, 148, 236820, 236758, 236813, 76066, 1239, 2307, 14485, 563, 5250, 28168, 236758, 236813, 107, 148, 236820, 575, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 24365, 176944, 28168, 236763, 236813, 138, 13886, 15335, 6178, 6571, 36513, 573, 1607, 1262, 9108, 532, 6675, 9047, 1554, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 9839, 12062, 28168, 236763, 236813, 1174, 5280, 36371, 506, 80864, 529, 1262, 7704, 528, 6571, 9047, 1554, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 4163, 70409, 28168, 236763, 236813, 138, 9208, 2256, 506, 2886, 529, 6571, 28606, 531, 3530, 27490, 653, 14845, 9047, 1554, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 24365, 37615, 28168, 236763, 236813, 138, 128583, 705, 6571, 14120, 740, 2080, 531, 3736, 28237, 9047, 1554, 236813, 107, 148, 954, 575, 236813, 107, 144, 954, 1928, 236813, 108, 144, 236820, 1928, 1012, 718, 1862, 905, 107, 148, 236820, 1928, 1012, 718, 1862, 236772, 3250, 905, 236774, 34149, 57939, 954, 1928, 236813, 107, 148, 236820, 236758, 236813, 8291, 659, 1070, 3364, 38738, 8403, 28168, 236758, 236813, 107, 148, 236820, 551, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 115863, 29179, 42056, 28168, 236763, 236813, 6890, 19791, 26295, 531, 8701, 6571, 117147, 9047, 1554, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 66649, 11338, 70409, 28168, 236763, 236813, 46532, 3104, 24027, 573, 11572, 1456, 27490, 9047, 1554, 236813, 107, 152, 236820, 1554, 1798, 236763, 236813, 59070, 23260, 35265, 28168, 236763, 236813, 110238, 7846, 1133, 2631, 5941, 6571, 9047, 1554, 236813, 107, 148, 954, 551, 236813, 107, 144, 954, 1928, 236813, 108, 144, 236820, 1928, 1012, 718, 1862, 905, 107, 148, 236820, 1928, 1012, 718, 1862, 236772, 3250, 905, 12703, 236787, 187810, 8645, 15335, 29179, 954, 1928, 236813, 107, 148, 236820, 236758, 236813, 34553, 2631, 5941, 6571, 27364, 506, 15963, 15335, 2509, 699, 37479, 919, 1082, 496, 3530, 2886, 529, 24051, 9047, 236758, 236813, 107, 148, 236820, 1734, 1798, 3970, 1012, 718, 3970, 236772, 5088, 905, 726, 14691, 4991, 531, 1076, 2631, 5941, 6571, 107, 726, 892, 236779, 32793, 756, 2074, 5941, 6571, 963, 236743, 236828, 236771, 236771, 236771, 138, 726, 5833, 531, 236743, 236828, 8242, 107, 726, 16861, 107, 726, 4769, 227362, 236793, 107, 954, 3970, 2588, 1734, 236813, 107, 144, 954, 1928, 236813, 108, 144, 236820, 1928, 1012, 718, 1862, 905, 107, 148, 236820, 1928, 1012, 718, 1862, 236772, 3250, 905, 19213, 954, 1928, 236813, 107, 148, 236820, 575, 236813, 107, 152, 236820, 1554, 1798, 236746, 3279, 718, 2574, 1411, 15143, 236761, 37322, 236761, 854, 236786, 501, 236772, 605, 236786, 9275, 236786, 42571, 236786, 3278, 236772, 32677, 236772, 118291, 236775, 3328, 21287, 15286, 905, 13886, 15335, 19791, 164042, 753, 9265, 20099, 954, 236746, 2588, 1554, 236813, 107, 152, 236820, 1554, 1798, 236746, 3279, 718, 2574, 1411, 15143, 236761, 37322, 236761, 854, 236786, 501, 236772, 605, 236786, 9275, 236786, 42571, 236786, 32677, 236772, 47805, 236772, 9275, 236772, 6458, 236775, 3328, 21287, 15286, 905, 52804, 15963, 15335, 3736, 753, 9265, 20099, 954, 236746, 2588, 1554, 236813, 107, 148, 954, 575, 236813, 107, 144, 954, 1928, 236813, 107, 140, 954, 1928, 236813, 108, 140, 236820, 14231, 236813, 107, 144, 236820, 236758, 29094, 10401, 236793, 236743, 236778, 236771, 236778, 236812, 9265, 20099, 954, 236758, 236813, 107, 140, 954, 14231, 236813, 108, 954, 3063, 236813, 107, 954, 3185, 236813, 107, 2717]