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
In today’s blog posting I want to give you a brief overview about my upcoming Speaking Schedule, and where you can meet me physically and virtually. From October 8 to 11 I’m speaking at the SQLdays Conference in Erding/Germany (near Munich). I’m giving here 2 full-day workshops and 2 regular sessions about the following topics: …
Last week VMware has released a new whitepaper with the very promising title “Architecting Microsoft SQL Server on VMware vSphere”. If you have a virtualized SQL Server running on top of VMware, this whitepaper is a MUST READ for you!!! I’ve read through the whitepaper over the last few days, and the content seems quite …
New Whitepaper: Architecting Microsoft SQL Server on VMware vSphere + read more
During one of my last Online Trainings about Extended Events, someone asked me about the Service Broker Target that Extended Events offers. To be honest, I had really no idea about this. So I had to check that target out, because in combination with Service Broker this would be an awesome functionality. As you can …
Over the last few days I have reworked my home network design, and introduced a new subnet for all my SQL Server based VMs that are running in my VMware vSAN powered Home Lab. In this blog posting I want to describe the various steps that are necessary to move a SQL Server Availability Group …
Moving a SQL Server Availability Group to a different Subnet + 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.
