Over the last weeks and months, I invested a lot of my time to get a better understanding of Hekaton – the new In-Memory technology that will be part of SQL Server 2014. I have done a lot of reading about the various internal data structures that Hekaton is using for its storage (mainly Hash …
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
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
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
Time flies by, and the year 2013 is almost over for me. So it’s time to announce the course schedule of the SQLpassion Academy for the next year. I’m running in March 2014 my SQL Server Performance Tuning & Troubleshooting Workshop across 4 different locations in Europe. Besides the usual locations I’m also running my workshop …
Announcing the SQLpassion Academy 2014 Course Schedule + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
