In-detail explanation of SQL Server memory utilization: Wisely troubleshoot SQL Server memory issues
In this session, I am going to talk about in detail how SQL Server utilizes memory.
You will get to know fundamentals of how Windows manages memory.
Afterwards, I will focus on SQL Server’s internal memory structures, how they are managed and how you can break down their usage for effective troubleshooting.
Topics covered:
Windows memory concepts
01:17 - Physical and virtual memory
3:40 - NUMA concept
5:35 - SQL Server NUMA architecture
SQL SERVER memory architecture
7:45 - Memory objects in SQL Server
8:48 - Memory clerks
13:00 - Target server memory
13:30 - Total server memory
17:20 - Resource monitor and Clock system for cash clean-up
19:35 - Working set and paging out
📚 ►Full course on Troubleshooting sessions: • Troubleshooting
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Gro...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP