by David Klee | Jan 21, 2024 | Database
You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance. Public cloud providers charge organizations for everything they deploy, and while a few items in the...
by David Klee | Nov 15, 2023 | Business, Cloud, Database, Infrastructure, Virtualization
A leading Metals Supplier had embarked on a journey to enhance their business operations with a new SQL Server-based ERP system. Excitement quickly turned into concern as they faced performance issues a few months into testing on a pre-production environment with a...
by David Klee | Sep 16, 2023 | Business, Cloud, Database, Infrastructure
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective (RPO) and Recovery Time Objective (RTO), and to have these defined not in...
by David Klee | Jul 13, 2023 | Business, Database, Infrastructure, News, Virtualization
In 2023, a US-based publicly traded automobile manufacturer enlisted Heraflux’s expertise to identify the root causes of multiple SQL Server Availability Group stability issues, and implement troubleshooting steps to optimize database performance. Because the SQL...
by David Klee | Jul 7, 2023 | Business, Cloud, Database, Events, Infrastructure, Video, 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 Klee | Feb 23, 2023 | Business, Database, Infrastructure, Virtualization
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...
by David Klee | May 18, 2022 | Database, Infrastructure, Virtualization
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...
by David Klee | Apr 24, 2022 | Database, Infrastructure
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....
by David Klee | Jul 8, 2021 | Cloud, Database
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...
by David Klee | Jun 15, 2021 | Database
Disasters big and small happen, and as data professionals, you should be prepared for the worst! I’m thrilled to announce that we’re launching the Microsoft Data Platform Continuity Virtual Group, starting with an open questions and answer session on June 23rd at 1pm...
Recent Comments