Actual Number of Rows are not always accurate

Today’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 more

SQLpassion Online Trainings in June 2018

Today 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 more

Replacing an ESXi Host in a vSAN Cluster

A 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

How to add Disks into a vSAN Disk Group

As you might know from my VMware vSAN powered Home Lab setup, I use an Intel Optane 900P Disk for the Caching Tier, and a Samsung 850 PRO 1 TB SSD Disk for the Capacity Tier. With just 3 ESXi hosts in my deployment, this gives me around 3 TB ...

Read more

What is VMware vSAN?

If you follow me on Twitter, or if you have read my last blog posting about my serious VMware Home Lab deployment, you might know that I really love and work with VMware vSAN. But what is VMware vSAN exactly, and can you use it to run SQL Server workloads ...

Read more
SQLpassion

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top