I’m a big believer in the SDDC (Software Defined Data Center), especially on the VMware platform. VMware provides you for a SDDC the following products/offerings: VMware ESXi Hypervisor for CPU and Memory Virtualization VMware vSAN for Storage Virtualization VMware NSX-T for Network Virtualization As you already know from my previous blog postings, I’m also a …
Today I want to talk about a specific kind of index in SQL Server: Filtered Indexes, which were introduced back with SQL Server 2008 – so already very long time ago. A Filtered Index is a traditional Non-Clustered Index, which includes a Filter Predicate that restricts the rows that are indexes in that specific index. …
As you might know from my Home Lab setup, I’m a big believer and fan of VMware vSAN, which is a Software-Defined Storage solution. Therefore I want to show you in today’s blog posting a step-by-step guide how you can create a vSAN based vSphere Cluster. For a basic understanding about the inner workings of …
Todays blog posting is a little bit more personal than technical. It seems that I don’t have that much luck this year, because since Sunday evening I have a broken right foot 🙁 I don’t want to go into the details about how it happened, but in the first step it seemed that I have …
In today’s blog posting I want to talk about Query Memory in SQL Server, and want to show you how fast it can degrade the performance of your queries. Before we dive into the details about how SQL Server is managing Query Memory, I want to talk briefly about what Query Memory actually is. Query …
Query Memory Grants and Resource Semaphores in SQL Server + 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.
