Today I’m quite happy to announce my upcoming SQLpassion Trainings for the next few months. Currently I have scheduled the following online trainings: SQL Server on Linux, Docker, and Kubernetes SQL Server Performance Troubleshooting I’m quite happy to provide a brand-new training about how to run SQL Server on Linux, Docker, and Kubernetes. The first …
My goal for last week was to get familiar with the HammerDB load generator and test-drive the TPC-C workload in my powerful Home Lab. This sounds like an easy task, because HammerDB automates all the necessary tasks for you. You can create the schema of the TPC-C database, and HammerDB will also populate the database …
One of the coolest new performance improvements in SQL Server 2019 is a better support for Scalar Valued Functions. As you (hopefully) know, Scalar Valued Functions always introduced a huge amount of performance problems – based on their implementation in SQL Server. Scalar Valued Functions prior SQL Server 2019 I don’t know a database which …
In today’s blog posting I want to talk more about the differences between the LSI Logic SAS and the VMware Paravirtual (PVSCSI) Controller that you can use in your VMware based Virtual Machines to attach VMDK files. LSI Logic SAS Controller If you add VMDK files to your Virtual Machine, VMware vSphere uses by default …
Benchmarking the VMware LSI Logic SAS Controller against the PVSCSI Controller + read more
As you might know, I’m running next week in Utrecht/Netherlands my SQL Server Performance Tuning & Troubleshooting Workshop. The agenda of this deep-dive workshop is quite impressive: Performance Tuning Fundamentals Extended Events Working with large Databases Transactions & Currency Lock Escalations Deadlocking Latches & Spinlocks Troubleshooting TempDb Performance Monitoring Performance Troubleshooting If you are interested …
Save 50% on my SQL Server Performance Tuning & Troubleshooting Workshop + 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.
