Blog Posts
- Just past the midpoint of Database Health Monitor Month
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …Just past the midpoint of Database Health Monitor Month Read More »
- History of Database Health Monitor: History, Milestones and Podcast
July marks Database Health Monitor Month at Stedman Solutions, and we are launching the celebration with a dedicated podcast episode that traces the tool’s origins and development over the years. Since its initial release in 2011, Database Health Monitor has steadily expanded through ongoing refinements to its diagnostic capabilities and feature set, giving SQL Server professionals deeper visibility into server activity and helping them address performance issues more effectively. July is Database Health Monitor Month! July …History of Database Health Monitor: History, Milestones and Podcast Read More »
- Database Health Monitor for SQL Server – Free Download and Trial
Managing SQL Server environments requires constant vigilance to maintain performance, prevent downtime, and optimize resources across multiple instances. Database Health Monitor for SQL Server addresses these needs with an accessible free trial that lets administrators explore its full range of monitoring tools without any initial commitment. This solution combines real-time visibility into database operations with flexible options for tracking key metrics, helping teams identify issues early and maintain reliable systems at any scale. The Database Health …Database Health Monitor for SQL Server – Free Download and Trial Read More »
- How Many Concurrent Users Can Your Query Actually Handle?
Every query has a breaking point. Run it for one user and it looks instant. Run it for fiftyusers at the same time and you might discover blocking, memory grant waits, or a CPU curvethat bends the wrong way. The trouble is, most teams find their query’s breaking point byaccident, in production, during the one week they could least afford it. Query Loading Ramp, included free with Database Health Monitor, has a feature builtspecifically to answer …How Many Concurrent Users Can Your Query Actually Handle? Read More »
- Built for Speed: The Lean Design Behind Database Health Monitor
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …Built for Speed: The Lean Design Behind Database Health Monitor Read More »
- Understanding Deadlocks in SQL Server with Database Health Monitor
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …Understanding Deadlocks in SQL Server with Database Health Monitor Read More »
- Seven Most Popular Features of Database Health Monitor
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …Seven Most Popular Features of Database Health Monitor Read More »
- SQL Server Load Testing Tool: Query Loading Ramp
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …SQL Server Load Testing Tool: Query Loading Ramp Read More »
- Understanding the Job History Report in Database Health Monitor
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …Understanding the Job History Report in Database Health Monitor Read More »
- Tracking SQL Server Database Changes with the Structure Change Log in Database Health Monitor
As part of Database Health Monitor Month this July, we are highlighting features in Database Health Monitor that help SQL Server professionals monitor, troubleshoot, and better manage their database environments. One powerful feature for tracking SQL Server database changes is the Structure Change Log report. If you have ever needed to know who changed a table, when a stored procedure was modified, or what SQL statement altered your database schema, the Structure Change Log provides a … - Blocking Query Monitor – Part of Database Health
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take …Blocking Query Monitor – Part of Database Health Read More »
- Database Health Features
Since adding two developers to the Database Health Monitor team, we have added many new Database Health Features. These have been covered on various episodes of the Stedman SQL Podcast outlined below. Check out the podcast and these new features added to Database Health Monitor. Stedman SQL Podcast Season 3 Episode 6 Database Health Monitor Recap and Updates In this episode of the Stedman SQL Podcast (Season 3, Episode 6), Steve Stedman is joined by Mitchell … - The Affordable SQL Server Monitoring Tool
If you’re a DBA or SQL Server professional shopping for a monitoring tool, you’ve probably experienced sticker shock. Many SQL Server monitoring tools on the market can run into the thousands of dollars per year, per server. That’s a real budget problem for anyone who just needs clean, reliable visibility into their SQL Server environments. That’s exactly where Database Health Monitor stands apart. Let’s break down the numbers. What Other SQL Server Monitoring Tools Cost The … - Table Use Report in Database Health
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take … - Database Health Quickscan – Default maintenance plans to shrink database – OuchShrinking a database can seem like a helpful way to save space and resources, particularly if a database has grown substantially over time. However, SQL Server’s default maintenance plans that include database shrinking can lead to several performance issues. Here’s why: Fragmentation: When a database is shrunk, the data pages are reorganized to create a contiguous block of free space at the end of the data file, which can cause severe fragmentation. This fragmentation can significantly …
Database Health Quickscan – Default maintenance plans to shrink database – Ouch Read More »
- What Is Database Health Monitor?
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung heroes safeguarding our precious data and to explore the intricate web of data structures and relationships within our systems. Let’s take … - Celebrating Database Health Monitor MonthWelcome 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 …
- How and When to Shrink SQL Server Log Files: Best Practices
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 »
- Stedman Solutions: Expert SQL Server Consulting Services for Performance, Security and Optimization
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 … - SQL Server Database Corruption Symptoms: 7 Warning Signs to Watch For
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: To Patch or Not to Patch?
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 »
- SQL Server Cost Threshold for Parallelism: Best Practices and Configuration
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 »
- Sneak preview – July is Database Health Monitor MonthJuly 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 »
- Why Is My SQL Server Slow? 8 Common Causes & Fixes
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 »
- Keyboard Shortcuts for Database Health Monitor
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 … - Missing Primary Keys in SQL Server: Hidden Risks and How to Fix Them
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 »
- How to Check and Update SQL Server Compatibility Levels with T-SQL
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 »
- sys.dm_os_performance_counters: SQL Server Performance Counters Guide
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 »
- How to Choose the Best SQL Server Performance Tuning Consultant
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 »
- How to Run DBCC CHECKDB in SQL Server: Beginner’s Guide
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 »
- DTA SQL Server Risks: How to Avoid Over-Indexing with Database Engine Tuning Advisor
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: Causes, Process and How to Fix It
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 »
- SQL Server Backup Types: Choosing the Right Strategy for Storage and Recovery Needs
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 »
- SQL Code Smells: Heap Tables
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 … - Understanding the Log Shipping Instance Report in Database Health Monitor
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 »
- Mastering sys.dm_os_schedulers: Optimize SQL Server Performance & CPU Usage
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 »
- Stedman SQL Server Podcast Episode 6: Latest Database Health Monitor Features & FixesWelcome 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 »
- SQL Code Smells: Non-Parameterized Queries
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 …