What is Memory Grants Pending in SQL Server? A short interview-style answer: what the counter shows, what value you want to see and why it matters.
SQL SERVER – How to Find the In-Memory OLTP Tables Memory Usage on the Server
At SQLPASS a DBA asked how to see the memory used by each In-Memory OLTP table. The DMV sys.dm_db_xtp_table_memory_stats answers it. Here is the script.
SQL SERVER – Error – Disallowing page allocations for database ‘DB’ due to insufficient memory in the resource pool
My SQL Server 2016 error log kept saying ‘Disallowing page allocations for database due to insufficient memory in the resource pool’. What it means and the fix.
Physical and Virtual Memory Explained for SQL Server DBAs
Physical and virtual memory are two different things, and SQL Server reports on both. This post explains RAM, address space, the page file and paging in plain words. It then reads each number with three read-only queries and ends with settings worth checking.
PowerShell – SQL Server Paging of Memory Identification
After a client case of memory pressure, I wrote a PowerShell script to spot SQL Server Paging, when SQL Server memory is being paged out to disk.
SQL SERVER – Delayed Durability, or The Story of How to Speed Up Autotests From 11 to 2.5 Minutes
My friend Sergey Syrovatchenko shares how Delayed Durability helped speed up autotests from 11 to 2.5 minutes on a SQL Server 2014 project.
SQL SERVER – Knowing Which Database is Consuming My Memory
Which database is consuming my memory? This query on sys.dm_os_buffer_descriptors counts buffer pool pages per database and page type.