I am both honored and privileged to have been selected to  present my “Deep Dive into SQL Server Batch Mode and CPU Architectures” at this event. I look forward to seeing you there if you are […]

This blog post will look at hyper-threading and the throughput it provides for OTLP workloads. How Does Hyper Threading Work ? This varies according to which generation of Intel processor you are talking about, for the purpose […]

This blog post consolidates most of the performance ‘Tweaks’ I have used in my blog posts to date. Many of the techniques I have used and blogged about relate to tuning SQL Server at scale, […]

The LOGCACHE_ACCESS spinlock is the final frontier when it comes to tuning SQL Server for OLTP workloads, this blog post will investigate how the NUMA node the workload is running on can have a massive impact […]