Fix SQL Server Msg 701, there is insufficient system memory in resource pool, when In-Memory OLTP tables run out of memory. With a script.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.
SQL SERVER – Beginning In-Memory OLTP with Sample Example
Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
SQL SERVER – SSMS: Memory Usage By Memory Optimized Objects Report
Why is SQL Server using all the memory? In-Memory OLTP in SQL Server 2014 makes it trickier. This SSMS report shows memory used by memory optimized objects.
SQL SERVER – SSMS: Memory Consumption Report
‘My SQL Server eats RAM and never gives it back’ is a common complaint. The SSMS Memory Consumption report shows where that memory goes and why.
SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026
I was once corrected on Page Life Expectancy. Here my friend Tim Radney explains in simple words what a good value for Page Life Expectancy really is.