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.
SQL SERVER – Understanding Basic Memory Terms of Physical Memory and Virtual Memory
A simple way to understand physical memory and virtual memory, the way I explained these basic memory terms to computer science students.
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.
SQL SERVER – How to View the Dirty Pages In Memory of a Database?
A GIDS attendee asked me how to tell which pages are dirty right now. Here is how to view the dirty pages in Memory for any database.