Sign in to confirm you’re not a bot
This helps protect our community. Learn more

SQL Server Diagnostic Memory Queries

Glenn Berry
5.6K subscribers
3.9K views 3 years ago ELIZABETH
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server. Memory usage in SQL Server is often poorly understood. These queries show you how to measure your memory usage to determine whether you are under internal or external memory pressure or both. They also help you understand which databases are using your memory and what indexes, queries and stored procedures are driving the memory usage. Finally, there are several queries in this set that help you find possible candidates for SQL Server data compression, which can be used to reduce your memory usage. These queries will work on SQL Server 2012 and newer. They will also work on SQL Managed Instance. Link to queries used in video: https://bit.ly/2XzlD1q Companion video: -- Estimating Data Compression Savings in SQL Server    • Estimating Data Compression Savings in SQL...   https:// …...more
...more
SQL Server Diagnostic Memory Queries
139Likes
3,955Views
2021Sep 19
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server. Memory usage in SQL Server is often poorly understood. These queries show you how to measure your memory usage to determine whether you are under internal or external memory pressure or both. They also help you understand which databases are using your memory and what indexes, queries and stored procedures are driving the memory usage. Finally, there are several queries in this set that help you find possible candidates for SQL Server data compression, which can be used to reduce your memory usage. These queries will work on SQL Server 2012 and newer. They will also work on SQL Managed Instance. Link to queries used in video: https://bit.ly/2XzlD1q Companion video: -- Estimating Data Compression Savings in SQL Server    • Estimating Data Compression Savings in SQL...   https://glennsqlperformance.com/2020/... ⏱️TIMESTAMPS⏱️ 0:00 Intro 0:17 What are we doing in this video? 0:35 System Memory 1:49 Max Server Memory 2:18 Process Memory 3:05 PLE by NUMA Node 4:03 Total Buffer Usage By Database 5:01 Memory Grants Pending 5:41 Memory Clerk Usage 7:23 Top Logical Reads Queries 9:12 SP Logical Reads 9:48 Table Sizes 11:39 Buffer Usage 14:40 Link to Estimating Data Compression Savings video 15:32 Bonus Chorizo footage 🔴 Please subscribe for more content like this! Links to Amazon and Newegg are typically monetized on my channel (affiliate links) and may return a commission of sales to me from the retailer. This is unrelated to the product manufacturer. SOCIAL =============================== 📝 - BLOG: https://glennsqlperformance.com/ 🐦 - TWITTER:   / glennalanberry   👥 - FACEBOOK:   / glenn.berry.92   LinkedIn:   / glberry   Host, Video: Glenn Berry

Follow along using the transcript.

Glenn Berry

5.6K subscribers