SQL Server Diagnostic Memory Queries

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 i...  
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