Introducing In-Memory Optimization in SQL Server

Query optimization techniques in SQL Server: the basics

Setting a fixed amount of memory for SQL Server

Monitor Memory Consumption for SQL Server Memory Optimized Tables

SQL Server memory performance metrics – Part 3 - SQL Server Buffer Manager metrics and memory counters

SQL Server memory performance metrics – Part 1 – Memory pages/sec and Memory page faults/sec

SQL Server monitoring tools for memory performance

SQL Server stress testing using OStress

SQL Server Lock Pages in Memory, AWE API and Windows Task Manager