by David | Feb 22, 2024 | Best Practices, Cloud, Performance, SQL Server, Storage
IT and data professionals, I implore you – know thy platform. All of it. Not just the layer your job is tasked with. Modern public cloud (or any infrastructure for that matter) platforms means there’s more to it than just one layer. Here’s an example from just...
by David | Jul 7, 2023 | Best Practices, Business, Cloud, Performance, Professional Development, SQL Server, Storage, Tech Video, Technology, Virtualization
My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason why you can’t join me in this adventure to learn more about how to performance and...
by David | Jul 29, 2021 | Best Practices, Cloud, Performance, SQL Server, Storage, Technology
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel 9 where I discuss setting up Linux storage appropriate for on-demand disk expansion for your production SQL Server on Linux workloads. I’ve been working with...
by David | Jul 8, 2021 | Best Practices, Performance, SQL Server, Storage, Technology
Do you have quite large MDF files on your database? By large, I mean hundreds of gigabytes (or larger). Have you ever noticed that your SQL Server disk stall metrics for these data files are much higher than the storage latency metrics exhibited on the underlying...
by David | Feb 23, 2021 | Best Practices, Performance, Storage, Technology, Virtualization
After doing some digging today with a Client, we hit a roadblock on something that I need to share with using the NVMe virtual disk controller on the VMware ESXi 6.5 and above platform. If you’re using this vDisk controller, you cannot expand or add virtual...
by David | Feb 1, 2018 | SQL Server, Storage, Virtualization
I recently had a great question on some of the differences in virtual machine disk presentation from one of our amazing clients, and I thought I’d share the answer here because it’s a common question that I receive. Some hypervisors (including some...