Do you have ever heard about an “Event-Less” Extended Event Session? What is the idea about it? Why do you want to have an Extended Event Session without any events? Let’s talk about it… Event Less When you create an Extended Event Session in SQL Server, the definition of the ...
Read moreIn today’s blog posting I want to talk about a very interesting topic: in which execution state is a query waiting on “something”? By definition we can all agree that a query always waits in the SUSPENDED state. But this behavior is not really true. So let’s talk about it… ...
Read moreToday’s blog posting is a quite interesting one, because I want to show you a concrete example where in an Actual Execution Plan the Actual Number of Rows are WRONG! Yes, you have read correctly: I’m talking here about the Actual Number of Rows, and not about the Estimated Number ...
Read moreToday I want to announce my SQLpassion Online Training for June 2018. On June 21, 2018 I’m running a one-day long webinar about SQL Server Troubleshooting with Extended Events. And because of the huge success of my brand new training Design, Deploy, and Optimize SQL Server on VMware, I will ...
Read moreA few days ago I have replaced in my vSAN enabled vSphere Cluster an ESXi Host in preparation for the upcoming migration to vSphere 6.7. As you know from my Home Lab deployment, my vSAN Compute Cluster consists of 3 HP Proliant Hosts: esx1.sqlpassion.com: HP DL380 G8 with Intel Xeon ...
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.
By confirming your subscription, we will store your email address and send you additionally emails about our upcoming trainings and about our published blog postings.
