Latest In

database storage

The High-Performance DBA: Total Recall, Part 1: SQL Server Memory Basics and Best Practices
May 7, 2026
Kevin Kline

This is the first of two connected posts on SQL Server memory management.

In this post, Kevin Kline explains how SQL Server uses memory, why memory becomes a bottleneck, and which configuration habits help create a more stable, high-performance environment. In the second post, we look at plan cache bloat, query patterns, and troubleshooting.

Database Storage Optimization for the High-Performance DBA
April 9, 2026
Kevin Kline

In this latest High-Performance DBA post, Kevin Kline explores what happens when SQL Server storage strategies fail to keep up with growing workloads.

When your DBAs are constantly firefighting I/O bottlenecks, TempDB contention, and uncontrolled log growth, the issue is not your team. It is your storage maturity. Address that, and you reduce incidents, free up DBA capacity, and ease operational strain.