Blog Posts

Welcome to July – a month that signifies a shift in focus to the unseen heroes of our digital infrastructure – our databases. As the founder of Database Health and Stedman Solutions, it is with great pleasure that I announce this month as Database Health Monitor Month! This annual event allows us to appreciate our precious data, explore the intricacies of our systems, and focus on enhancing the health of our databases. This July, let’s not …

Celebrating Database Health Monitor Month Read More »

Managing SQL Server transaction log files often presents unexpected hurdles for database teams when deciding how and when to shrink SQL Server log files, especially when rapid growth threatens available disk space. These files play a vital role in recording every change to the database, yet their expansion can quickly outpace initial expectations if underlying activity or configuration issues go unaddressed. Many administrators reach for the shrink command as an immediate remedy, but doing so without …

How and When to Shrink SQL Server Log Files: Best Practices Read More »

In today’s data-driven landscape, businesses rely heavily on robust SQL Server environments to manage critical operations, yet many struggle with performance bottlenecks, security gaps, and inefficient resource allocation. Stedman Solutions stands out as a specialized Consulting firm dedicated to addressing these challenges through targeted expertise in database management and optimization. With a focus on delivering practical strategies that align with unique organizational needs, their services encompass everything from query tuning and system scalability to proactive security …

Stedman Solutions: Expert SQL Server Consulting Services for Performance, Security and Optimization Read More »

Common Symptoms of Corruption in a SQL Server Database SQL Server database corruption is a serious concern that can strike without warning, potentially leading to data loss, failed queries, and costly downtime for organizations that rely on their databases every day. Whether caused by hardware failures, disk errors, or unexpected system issues, corruption often leaves database administrators scrambling to identify the problem before it escalates. Recognizing the early indicators is essential for maintaining database integrity and …

SQL Server Database Corruption Symptoms: 7 Warning Signs to Watch For Read More »

SQL Server Patching Risks: Why Patching vs. Not Patching Matters Patching SQL Server often presents database administrators with a difficult choice between maintaining security and avoiding potential disruptions. While updates address known vulnerabilities and improve stability, applying them can sometimes lead to compatibility problems or unexpected downtime that affects business operations. At the same time, delaying or skipping patches leaves systems exposed to evolving threats, performance degradation, and regulatory concerns that grow more severe over time. …

SQL Server Patching Risks: To Patch or Not to Patch? Read More »

Understanding SQL Server Cost Threshold for Parallelism Optimizing SQL Server performance often comes down to fine-tuning configuration options that control how queries are executed. One frequently overlooked but critical setting is the Cost Threshold for Parallelism, which influences whether the database engine chooses to run operations across multiple CPU cores or sticks to a single thread. When this threshold is set too low, SQL Server may parallelize queries that would run more efficiently without the overhead …

SQL Server Cost Threshold for Parallelism: Best Practices and Configuration Read More »

July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this month as Database Health Monitor Month! This is our annual opportunity to appreciate the often-unseen guardians of our valuable data, and to dive deeper into the heartbeat of our systems, replete with intricate data structures and …

Sneak preview – July is Database Health Monitor Month Read More »

SQL Server performance dashboard highlighting query bottlenecks and resource usage If your SQL Server suddenly starts dragging, the ripple effects can quickly reach every corner of your organization. Reports that once loaded in seconds now time out, transactions pile up, and end users begin to lose confidence in the systems they rely on every day. Pinpointing the exact culprit is rarely straightforward, yet most slowdowns stem from a handful of recurring issues that can be systematically …

Why Is My SQL Server Slow? 8 Common Causes & Fixes Read More »

Over the years developing Database Health Monitor I have added a number of keyboard shortcuts to make life easier when working in the application. Some of these are listed here to share since they are not all completely obvious. Backspace Key – Jump to the last report viewed The Backspace key can be used to jump to the previous report that you were viewing. Not just that, but hit it multiple times and you can browse …

Keyboard Shortcuts for Database Health Monitor Read More »

In the world of database administration, few oversights carry as much weight as the absence of primary keys on SQL Server tables. While it might seem like a minor detail during initial setup or rapid development, this missing element can quietly undermine the stability and efficiency of even the most critical systems over time. Primary keys serve as the backbone of reliable data management by guaranteeing unique identification for every row. Without them, queries become harder …

Missing Primary Keys in SQL Server: Hidden Risks and How to Fix Them Read More »

When you need to check compatibility level SQL Server after upgrading, start by reviewing the compatibility levels assigned to your databases. These settings determine which features and behaviors are available, directly influencing query performance and application stability during and after the upgrade process. Without a clear view of current compatibility levels across all databases, teams risk overlooking instances that could benefit from newer functionality or that might encounter unexpected issues. A quick and reliable method to …

How to Check and Update SQL Server Compatibility Levels with T-SQL Read More »

In the world of database administration, keeping a close eye on performance metrics using sys.dm_os_performance_counters is vital for ensuring SQL Server instances run efficiently. This DMV helps DBAs track memory allocation, buffer management, and transaction throughput to spot issues before they impact users. One particularly useful resource comes in the form of dynamic management views that expose detailed counter data collected by the database engine. These views offer a direct window into internal operations, making it …

sys.dm_os_performance_counters: SQL Server Performance Counters Guide Read More »

Navigating the complexities of SQL Server performance issues can be a daunting task for any organization. When your database starts to lag, impacting business operations, finding the right expert becomes critical. A skilled SQL Server Performance Tuning Consultant by Stedman Solutions can transform your system’s efficiency, but the challenge lies in identifying the best fit for your specific needs. The market is filled with consultants claiming expertise, yet not all possess the specialized knowledge required for …

How to Choose the Best SQL Server Performance Tuning Consultant Read More »

Database administrators know that even the most carefully maintained SQL Server environments can encounter unexpected integrity problems. Over time, hardware issues, unexpected power loss, or software bugs can introduce subtle database corruption that may go unnoticed until it affects application performance or causes data loss. DBCC CHECKDB remains one of the most thorough and widely used commands for detecting these problems early. By examining allocation structures, index relationships, and page consistency, the command provides a clear …

How to Run DBCC CHECKDB in SQL Server: Beginner’s Guide Read More »

The Database Engine Tuning Advisor (DTA) helps avoid over-indexing risks in Microsoft SQL Server by analyzing workloads and suggesting safer index changes. At its core, DTA processes workload data such as trace files or query scripts to simulate the effects of potential modifications, including new indexes, updated statistics, and table partitioning schemes. This analysis aims to provide actionable scripts that DBAs can review and apply selectively, rather than requiring manual trial-and-error tuning for every workload variation. …

DTA SQL Server Risks: How to Avoid Over-Indexing with Database Engine Tuning Advisor Read More »

SQL Server Recovery Pending state occurs when the engine detects inconsistencies after an improper shutdown and must run automatic recovery before users can access the database. The underlying recovery process replays committed transactions and rolls back incomplete ones using the transaction log. While this mechanism protects data integrity, prolonged recovery times can disrupt operations and raise questions about potential underlying problems. In the sections that follow, we examine the common triggers for Recovery Pending messages, the …

SQL Server Recovery Pending: Causes, Process and How to Fix It Read More »

Protecting SQL Server databases requires more than simply scheduling routine backups. As data volumes grow and business operations become increasingly dependent on continuous availability, the choice of backup strategy directly influences both storage costs and the ability to recover quickly from failures or disasters. Different backup types offer distinct advantages and limitations. Full backups provide complete copies of the database but consume substantial space and time, while differentials and transaction log backups capture only changes since …

SQL Server Backup Types: Choosing the Right Strategy for Storage and Recovery Needs Read More »

You inherit a database and start digging through the schema. Everything looks reasonable on the surface until you notice a handful of tables with no clustered index. No obvious reason. They just never got one. In some cases they have been sitting that way for years, quietly degrading read and write performance while nobody thought to look. Heap tables are one of those code smells that tend to accumulate in the background. They do not cause …

SQL Code Smells: Heap Tables Read More »

Understanding the Log Shipping Instance Report in Database Health Monitor Log shipping has been a staple in SQL Server for what feels like forever, and for good reason. It’s a reliable, time-tested solution for Disaster Recovery, particularly for scenarios where you need a secondary site to ensure data availability. While some might argue that Replication or availability groups are more modern alternatives, log shipping remains a solid choice for many organizations due to its simplicity and …

Understanding the Log Shipping Instance Report in Database Health Monitor Read More »

Diving into the intricacies of SQL Server Performance Tuning Tips tuning can be a game-changer for database administrators and developers alike. One of the most powerful tools at your disposal is the sys.dm_os_schedulers dynamic management view (DMV). This invaluable resource offers a detailed look into how SQL Server manages CPU resources through its schedulers, providing critical insights into task allocation and potential performance bottlenecks. Understanding sys.dm_os_schedulers is essential for anyone looking to optimize CPU usage and …

Mastering sys.dm_os_schedulers: Optimize SQL Server Performance & CPU Usage Read More »

Welcome to a deep dive into Episode 6 of the Stedman SQL Server Podcast, where we unpack the latest enhancements to Download Database Health Monitor Tool , a vital tool for SQL Server users seeking to optimize performance and reliability. This episode is packed with insights on new features and critical fixes that make Database Health Monitor an even more indispensable part of your database management arsenal. Whether you’re a seasoned DBA or just starting out, …

Stedman SQL Server Podcast Episode 6: Latest Database Health Monitor Features & Fixes Read More »

Your SQL Server is running hot. CPU is elevated, the plan cache is bloated, and queries that should be instant are taking seconds. You look at the query text and everything seems reasonable. The problem is not what the queries are doing. It is how they are being sent. Non-parameterized queries are one of the most common performance problems in SQL Server environments, and one of the easiest to overlook because the queries themselves often look …

SQL Code Smells: Non-Parameterized Queries Read More »

Are you struggling with slow database queries or unexpected downtime in your SQL Server environment? At Stedman Solutions, we understand how critical performance and stability are to your business operations. Our SQL Server Performance Assessment is a comprehensive evaluation designed to pinpoint inefficiencies and provide tailored solutions to supercharge your database performance. Through a meticulous process, we dive deep into every aspect of your SQL Server setup, from configuration settings to query execution plans. Our team …

SQL Server Performance Assessment: Boost Speed and Stability with Stedman Solutions Read More »

Features in Database Health Monitor: Job History, Problem Indexes, and Backup Reports At Stedman Solutions, we are always working to make SQL Server management easier and more effective. Database Health Monitor continues to evolve with new reports and enhancements designed to help SQL Server administrators better understand what is happening across their environments. Some of the latest additions focus on three critical areas: SQL Server job activity Problematic indexes Backup visibility and reporting These new features …

Database Health Monitor Features: Job History Charts, Problem Indexes & Backup Reports for SQL Server Read More »

SQL Server error logs serve as a vital resource for diagnosing performance issues, security events, and unexpected failures within a database environment. When these logs become inaccessible, database administrators lose a primary source of diagnostic information at the exact moment it is needed most. This situation can quickly escalate routine troubleshooting into a prolonged and frustrating process. Common triggers for inaccessibility include oversized log files that exceed practical viewing limits, misconfigured file system permissions, and SQL …

SQL Server Error Logs Inaccessible: Causes, Fixes & Prevention Read More »

The Ultimate SQL Server Backup Strategy: Protecting Your Data from Disaster and Corruption In today’s data-driven environments, SQL Server databases often serve as the backbone for critical business operations, making their protection against unexpected failures, data corruption, and catastrophic events a top priority for IT teams everywhere. Many organizations operate without a truly robust backup plan in place, only recognizing the gaps in their approach after an outage or integrity issue has already caused significant disruption …

SQL Server Backup Strategy: Protect Data from Disaster, Ransomware & Corruption Read More »

The Hidden SQL Server Performance Killer: Implicit Conversions When SQL Server Performance issues begin appearing, many companies assume the only solution is to add more hardware, increase cloud resources, or purchase additional SQL Server licenses. In reality, some of the biggest performance problems come from small development decisions that quietly consume CPU resources over time. One of the most overlooked examples of this is implicit conversions in SQL Server. Implicit conversions occur when SQL Server automatically …

The Hidden SQL Server Performance Killer: Implicit Conversions Read More »

Catching Failing Database Health Monitor Jobs with Check 239 Catching Failing Database Health Monitor Jobs with Check 239 One of the most valuable aspects of Database Health Monitor is its ability to watch for issues that might otherwise go unnoticed until they become much larger problems. Check 239 is a great example of this proactive approach to SQL Server monitoring. Check 239 specifically monitors for failing Database Health Monitor jobs. Why Database Health Monitor Jobs Matter …

Catching Failing Database Health Monitor Jobs Read More »

Are you aware of the true financial burden of managing SQL Server in-house? Many organizations underestimate the hidden costs that go beyond salaries, including tools, training, and the risk of costly downtime. Our latest white paper, “The Real Cost of SQL Server Management: In-House Team vs. Stedman Solutions,” uncovers the full spectrum of expenses and challenges that come with maintaining an internal database team. From hiring skilled DBAs to investing in specialized software, the expenses of …

The Real Cost of SQL Server Management: Download Our White Paper Now Read More »

Optimizing SQL Server Backups for Performance and Reliability Effective backup strategies are essential for protecting SQL Server environments from data loss while maintaining acceptable performance levels. By focusing on compression, striping, and thoughtful scheduling, database administrators can reduce backup windows and improve overall reliability without sacrificing recoverability. Backup Compression Enabling backup compression reduces the size of backup files and lowers the amount of data written to disk. This typically shortens backup duration and decreases storage requirements. …

Optimizing SQL Server Backups for Performance and Reliability Read More »

CPU Drill-Down Feature in Database Health Monitor A powerful capability has arrived in Database Health Monitor, making CPU troubleshooting faster and more intuitive. For years, DBAs relied on two separate views: CPU by Database and CPU by Query. Each provided insight, but there was no direct connection between them. That changes now. The Problem: Lack of Context The CPU by Database report showed which database used the most CPU, but not why. CPU by Query listed …

CPU Drill-Down Feature in Database Health Monitor Read More »

In the fast-paced world of database management, maintaining peak performance for SQL Server environments is a top priority. Download Database Health Monitor for SQL Server emerges as a standout solution, offering unparalleled insights into the health and efficiency of your databases. This powerful tool is designed to empower database administrators and developers alike with the ability to proactively address issues before they impact operations. Unlike other monitoring tools that merely scratch the surface, Database Health Monitor …

Database Health Monitor: The Best SQL Server Monitoring Tool for Optimal Performance Read More »

SQL Server data Aggregation is a game-changer for anyone looking to extract meaningful insights from vast datasets. By harnessing the power of aggregation functions, you can summarize, analyze, and transform raw data into actionable information. Whether you’re a database administrator or a business analyst, mastering these techniques is essential for unlocking the full potential of your data. At its core, data aggregation in SQL Server allows you to perform calculations like summing values, finding averages, or …

SQL Server Data Aggregation: Master Powerful Data Insights Read More »

In the realm of database management, ensuring optimal performance of your SQL Server is not just a technical necessity but a business imperative. At Stedman Solutions, we recognize that a sluggish or inefficient SQL Server can hinder operations, frustrate users, and impact your bottom line. That’s why we specialize in comprehensive performance assessments designed to identify bottlenecks and unlock the full potential of your database environment. A SQL Server Optimization Assessment from Stedman Solutions goes beyond …

SQL Server Performance Assessment: Boost Efficiency with Stedman Solutions Read More »

Database performance is a critical factor in ensuring that applications run smoothly and efficiently, and index management plays a pivotal role in this equation. Indexes can transform sluggish queries into lightning-fast operations by providing SQL Server with efficient pathways to data. However, the art of index management lies in finding the sweet spot—too many or too few indexes can tip the scales toward inefficiency, storage bloat, or performance bottlenecks. Striking the right balance in index management …

Database Performance: How to Balance Index Management for Optimal Results Read More »

Learn about SOS_SCHEDULER_YIELD wait type in SQL Server: uncover causes like CPU contention and solutions for performance tuning with expert tips. This wait type surfaces when a task voluntarily relinquishes its CPU time to allow other tasks to run, a natural part of SQL Server’s cooperative scheduling model. However, when these waits become frequent or prolonged, they can point to underlying issues that degrade system performance, making it crucial to understand their implications. At its core, …

Decoding SOS_SCHEDULER_YIELD Wait Type in SQL Server: Causes and Solutions Read More »

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index management and discuss strategies to identify and remove unnecessary indexes without compromising system stability. The Dilemma …

Dangers of Removing Indexes Read More »

Managing table sizes in SQL Server is an essential task for any database administrator looking to maintain optimal performance and efficient storage usage. Large or rapidly growing tables can lead to slower queries, increased backup times, and potential bottlenecks. In this post, we’ll explore practical methods to check table sizes using T-SQL scripts and introduce helpful tools to simplify the process. Knowing the size of your tables isn’t just about keeping track of storage; it’s about …

How to Check Table Sizes in SQL Server Using T-SQL and Tools Read More »