SQLpassion BLOG

Query Memory Grants and Resource Semaphores in SQL Server

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

My upcoming Speaking Schedule

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: …

My upcoming Speaking Schedule + read more

New Whitepaper: Architecting Microsoft SQL Server on VMware vSphere

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