SQLServer

How Hekaton will impact the RTO of your database

Over the weekend I have encountered a very interesting side effect of Hekaton in SQL Server 2014, which unfortunately impacts your RTO (Recovery Time Objective) of your database in a negative way. As you know, Hekaton creates for every native compiled Table and Stored Procedure a DLL, which contains the native implementation in C code. …

How Hekaton will impact the RTO of your database + read more

Choose your Hash Bucket Count very wisely in Hekaton!

Today I have encountered a very simple blog posting where someone was inserting 1 millions of rows into a Hekaton Hash Index of 2048 buckets. Therefore I was running some tests how Hash Collisions in the Hash Buckets will affect the throughput of your Hekaton workload – and the results are very, very interesting. In …

Choose your Hash Bucket Count very wisely in Hekaton! + read more

My SQLrally Session about how to measure Index Impact Changes

During the current week I have spoken at 2 SQLrally conferences, once in Stockholm/Sweden, and once in Amsterdam/Netherlands. At both conferences I have presented my brand-new session titled “How to measure Index Impact Changes”. The goal of the session is very easy: imagine you want to change your Indexing Strategy in for your production system, …

My SQLrally Session about how to measure Index Impact Changes + read more