Author: Steve Stedman

Indexes are one of the most powerful tools for improving query performance in SQL Server.When designed correctly they can dramatically reduce I/O, speed up queries, and improveapplication responsiveness. However, indexes are not free. Every index adds overhead to INSERT, UPDATE, and DELETEoperations, increases storage requirements, and must be maintained over time. Because of this, poorly configured, unused, or disabled indexes can create more harm thanbenefit. They consume storage, slow down write operations, and add unnecessary maintenancework without improving query performance. …

Problematic Indexes Read more »

What is Wait Statistics Monitoring in SQL Server? SQL Server performance tuning can often feel like solving a complex puzzle, with countless variables impacting how efficiently your database operates. One of the most critical pieces of this puzzle is understanding what your server is waiting on—those moments when tasks are delayed due to resource contention or bottlenecks. This is where wait statistics monitoring comes into play, offering a window into the inner workings of SQL Server and revealing the root …

Wait Statistics Monitoring WIth Database Health Monitor Read more »

Large Differential BACKUPs: Understanding the Risks and Solutions

SQL Server Concerns That Keep IT Managers Awake at Night For IT managers, the responsibility of overseeing SQL Servers often comes with sleepless nights. These critical systems underpin business operations, and any hiccup can lead to costly downtime, frustrated users, or even data loss. The pressure to maintain performance, security, and reliability is relentless, as even a minor issue can snowball into a major crisis. From performance bottlenecks to security breaches, the list of potential problems with SQL Servers is …

SQL Server Concerns That Keep IT Managers Awake at Night Read more »

Unplanned downtime can strike any business at any time, bringing operations to a grinding halt and leaving a trail of financial and operational challenges in its wake. Whether you run a small ecommerce store or manage a large enterprise with complex IT systems, the cost of unexpected outages goes far beyond a temporary inconvenience. Understanding the true cost of unplanned downtime is the first step toward mitigating its impact and safeguarding your bottom line. Every business is unique, which means …

Calculating the True Cost of Unplanned Downtime: A Guide for Every Business Read more »

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 »