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
On June 24, 2019 I’m running a one-day long webinar about SQL Server Query Tuning Fundamentals. In this one-day long webinar you will learn about: How to access your data through Indexes Heap Tables Clustered Index Non-Clustered Index Index Scans Index Seeks Execution Plans Overview Estimated Execution Plan Actual Execution Plan Data Access Operators Join …
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.
