Database Articles

SQL Server on VMware Accelerator now free!

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 availability tune your SQL...

Architecting MS SQL Server on VMware vSphere 8.0 released

I'm thrilled to announce that the "Architecting Microsoft SQL Server on VMware vSphere" 8.0 best practices guide has been released! I'm pleased to have been able to contribute to this document. This document covers some very positive and significant changes VMware has...

VMware & SQL Server 823-824 alerts

We've been tracking a weird state with SQL Server virtual machines on VMware and possible warnings on database corruption while VM backups are running, largely centered around (but not isolated to) the tempdb database. TLDR: We've now got a VMware KB article on this...

Add Disk Performance Counters to Windows Task Manager

Have you ever wondered why Windows Server doesn't show disk performance metrics in Task Manager, but your Windows 10/11 OS does? It's a really silly difference. Let's fix that. Open PowerShell or the command prompt with administrative permissions. Run "diskperf -y"....