Author: Steve Stedman

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 this question on purpose, …

How Many Concurrent Users Can Your Query Actually Handle? Read more »

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 a closer look at …

Built for Speed: The Lean Design Behind Database Health Monitor Read more »

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 a closer look at …

Understanding Deadlocks in SQL Server with Database Health Monitor Read more »

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 a closer look at …

Seven Most Popular Features of Database Health Monitor Read more »

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 a closer look at …

SQL Server Load Testing Tool: Query Loading Ramp Read more »

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 a closer look at …

Understanding the Job History Report in Database Health Monitor Read more »

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 clear and searchable history …

Tracking SQL Server Database Changes with the Structure Change Log in Database Health Monitor Read more »

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 a closer look at …

Blocking Query Monitor – Part of Database Health Read more »

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 Glasscock and George Stedman …

Database Health Features Read more »

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 a closer look at …

Table Use Report in Database Health Read more »