Year: 2026

SQL Server Wait Types Causing Blocking: Key Insights and Solutions In the complex world of SQL Server performance tuning, understanding wait types is crucial for identifying bottlenecks and ensuring smooth operations. Wait types are essentially indicators of what SQL Server processes are waiting for, and while some waits are benign, others can directly contribute to blocking—a situation where one process holds a lock on a resource, forcing others to wait. This blocking can cascade, leading to significant performance issues if …

SQL Server Wait Types Causing Blocking: Key Insights and Solutions Read more →

Stedman Solutions introduces, Peace of Mind Month, granting you satisfaction and reassurance for your SQL Server through Managed Services. The month of March is “Peace of Mind Month” for us at Stedman Solutions. In the dynamic landscape of technology, the ever-evolving intricacies can be a labyrinth for many. Business leaders often confess, “I lack the knowledge to maintain our database.” Recognizing this common concern, Managed Services emerges as the beacon of expertise, bridging the knowledge gap to ensure not only …

March is Peace of Mind Month Read more →

Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the Blocking Query Monitor. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health Read more →

If you’ve ever looked at a slow SQL Server system and thought, “We probably need better indexes,” you’re not alone. The hard part usually isn’t knowing that indexing matters. It’s knowing where to start. Most environments have hundreds (or thousands) of tables. Many already have indexes. Some have too many. And if you start guessing, you can easily end up with indexes that don’t help, don’t get used, or worse, slow down writes and inflate storage. That’s why Database Health …

Adding New Indexes: Where Do You Start? Read more →

When it comes to fine-tuning SQL Server for optimal performance, database administrators often explore a variety of settings to squeeze out every bit of efficiency. One such setting, “Boost SQL Server Priority,” might catch your eye with its enticing name, promising to elevate SQL Server’s performance above other processes. However, before you rush to enable this option, it’s critical to understand what it truly does and the potential risks it carries. This setting, buried within SQL Server’s configuration options, adjusts …

Boost SQL Server Priority: Understanding Risks and Best Practices for Performance Tuning Read more →

Understanding SQL Server Error Severity Levels 19 through 25: A Comprehensive Guide SQL Server employs error severity levels to categorize and communicate the seriousness of issues encountered during database operations. These severity levels span from 0 to 25, encompassing a wide range of problems, from minor informational messages to devastating system failures. In this detailed blog post, we will dive deep into severity levels 19 through 25, which represent the most critical and urgent errors in SQL Server. Understanding these …

SQL Server Error Severity Levels 19-25: Critical Issues Explained Read more →

Understanding and Resolving SQL Server Error 18456 If you’ve been working with SQL Server for a while, chances are you’ve encountered the dreaded “Login failed for user” error, known as Error 18456. This error is one of the most common authentication issues in SQL Server, and it can be frustrating because it doesn’t always give a clear explanation of the root cause. In this blog post, I’ll dive into what SQL Server Error 18456 is, why it occurs, and how …

How to Fix SQL Server Error 18456: Causes and Solutions Read more →

What Are SQL Agent Jobs and Why Do They Matter? If you’ve been working in a SQL Server environment for any length of time, you’ve likely encountered SQL Server Agent Jobs. But what exactly are these jobs, and why are they considered a cornerstone of efficient database management? Whether you’re a seasoned database administrator (DBA) or just starting out, understanding SQL Agent Jobs is crucial for maintaining a healthy and optimized SQL Server. In this comprehensive blog post, we’ll dive …

Understanding SQL Server Agent Jobs: A Guide to Automation and Efficiency Read more →