How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution .
2016-05-16
3,732 reads
In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.
2016-02-04
3,523 reads
I/O latch can cause session delays that impact application performance. This white paper describes the procedures and common I/O latch issues when migrating to Hekaton in SQL Server 2014. It also includes challenges that occurred during the migration and the performance analysis at different stages.
2016-01-25
2,632 reads
Aaron Bertrand takes a look at the changes in store for In-Memory OLTP (the feature formerly known as "Hekaton").
2015-12-17
5,473 reads
The article demonstrates one of the major performance enhancements in checkpoint processes in "in memory tables"
2018-10-05 (first published: 2015-10-27)
3,720 reads
2015-08-17
4,171 reads
Steve Jones is searching for anyone that is using In-Memory OLTP tables in production.
2015-06-11
155 reads
In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.
2020-12-30 (first published: 2015-05-13)
55,467 reads
When SQL Server 2014 was released, it included Hekaton, Microsoft’s much talked about memory-optimized engine that brings In-Memory OLTP into play. With memory-optimized tables 30 times faster than disk-based tables, higher performance is promised – but at what cost? Jonathan Watts looks at the features that have improved, and those that need careful consideration.
2015-02-20
10,562 reads
2015-02-19
1,753 reads
In terms of encryption, Key Rotation is the process of replacing your encryption keys...
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Hi, I have four views on one database to which one sql authenticated user...
Comments posted to this topic are about the item Schedule Jobs on a Clustered...
Comments posted to this topic are about the item Encrypting the Database Encryption Key
Ask SSC