Author: Roy Ernest

Pro Members SQL Server Standard Members

Memory management for In-Memory OLTP Server – Part 1

by

Memory management for In-Memory OLTP Server Part-1 Microsoft introduced a new functionality in SQL 2014 namely memory optimized objects. As the name implies, this technology is about having tables reside in memory. This means that the memory usage on your database will be much higher. In this series of articles we will see how we can manage the memory in...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Memory management for In-Memory OLTP Server – Part 2

by

Memory management for In-Memory OLTP Server – Part II In my previous article, we saw how to calculate the memory needed for memory based objects when using In-Memory technology that was introduced in SQL Server 2014 version. We also saw how we can monitor the memory usage by these objects. In this article we will see how we can make...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →