Year: 2025

By Posted on Posted in Uncategorized

How Critical Is Your SQL Server Performance? Understanding the Impact of Slowdowns When it comes to managing SQL Server, performance isn’t just a number on a dashboard—it’s the heartbeat of your organization’s data-driven operations. Having spent years immersed in the intricacies of SQL Server environments, I’ve seen how peak performance can propel businesses forward, streamlining processes and empowering decisions. But I’ve also seen the flip side: the chaos and frustration that erupt when slowdowns take hold. This isn’t a topic …

How Critical Is Your SQL Server Performance? Read more »

By Posted on Posted in Uncategorized

Three Fantastic Ways to Master SQL Server Join Types Hey there, SQL enthusiasts and database professionals! It’s Steve Stedman from Stedman Solutions, LLC. Today, I’m excited to share with you three incredible ways to enhance your understanding of SQL Server join types. Whether you’re a beginner or looking to polish your skills, we’ve got something just for you! 1. Grab Your Free Join Types Poster First up, we’re offering a FREE downloadable poster that visually breaks down SQL join types. …

Four Fantastic Ways to Master SQL Server Join Types Read more »

By Posted on Posted in Uncategorized

I just wanted to let you know that the deadlock tracking has been extremely useful in tracking down issues. Without the tools, it’s was easy to see that one side of the process would fail occasionally, but it was hard to see what process won the deadlock. This is a gamechanger for me. I just wanted to say thanks to you and the team for adding this functionality. Eric – Database Health Monitor User Deadlock Tracking Reports in Database Health …

Deadlock Reports – A Gamechanger Read more »

By Posted on Posted in SQL Server Performance Tuning

Understanding the Quick Scan Report: Backup to NUL The Hidden Risks of SQL Server Backups: Beyond the Basics When it comes to managing SQL Servers, backups are a cornerstone of data protection—but their effectiveness hinges on more than just their existence. Too often, administrators focus solely on scheduling backups without delving into the critical details that determine their reliability. One such overlooked yet perilous practice is backing up to a NUL device. While this technique has niche applications, such as …

Backup to NUL Read more »

By Posted on Posted in Uncategorized

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. The Risks of Storing User Tables in MSDB: Insights from Database Health Monitor Managing SQL Server effectively requires following best practices and avoiding common pitfalls that can impact performance, security, and maintenance. One often-overlooked issue is the practice of storing user tables in the MSDB database. While it may seem convenient at first, this approach introduces multiple …

Risks of Storing User Tables in MSDB Read more »

By Posted on Posted in Uncategorized

Common Uses of TempDB in SQL Server TempDB is one of the most critical system databases in SQL Server. It serves as a globally available, temporary storage area used by the SQL Server Database Engine for various operations. Unlike other databases, TempDB is recreated each time SQL Server restarts, ensuring that no persistent data is stored. Due to its frequent and intensive use, TempDB performance is crucial to overall SQL Server Performance. Below are the most common uses of TempDB: …

Common Uses of TempDB? Read more »

By Posted on Posted in Uncategorized

Tidying Up Your SQL Server: Removing Leftover DTA Tables SQL Server administrators and developers often use the Microsoft Database Tuning Advisor (DTA) to analyze and enhance database performance. While DTA is an effective tool, it tends to leave behind monitoring tables in the msdb database after its use. Why Do These Tables Exist? When you run the Database Tuning Advisor, it creates temporary tables to store analysis data. If DTA doesn’t clean up properly due to an interrupted session or …

Leftover Databse Tuning Advisor Tables Read more »

By Posted on Posted in Uncategorized

Mastering SQL Server Performance: The Power of Cost Threshold for Parallelism In the intricate dance of SQL Server performance tuning, few settings wield as much influence as the Cost Threshold for Parallelism (CTFP). This unassuming configuration parameter is a linchpin in determining how SQL Server harnesses the power of parallel query execution—spreading workloads across multiple CPU cores to boost speed. But like any powerful tool, it’s a double-edged sword: wield it wisely, and you unlock blazing performance; misuse it, and …

SQL Server: Cost Threshold for Parallelism Read more »

By Posted on Posted in Uncategorized

Understanding the LOGMGR_RESERVE_APPEND Wait Type in SQL Server Need help with this wait type or others, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. Understanding the SQL Server LOGMGR_RESERVE_APPEND Wait Type In SQL Server, the LOGMGR_RESERVE_APPEND wait type occurs when a thread is waiting to reserve space in the transaction log before writing a new log record. Since the transaction log plays a crucial role in ensuring data durability, crash …

LOGMGR_RESERVE_APPEND Wait Type in SQL Server Read more »

By Posted on Posted in Uncategorized

At Stedman Solutions, we understand the challenges that come with managing SQL Server databases. Whether it’s query optimization, Performance Tuning, or Disaster Recovery, we’ve seen it all. That’s why we created the Stedman SQL Server Podcast—a resource for database professionals looking to improve their SQL Server environments. One of Our Most Popular Episodes: Indexing for Performance One of our most popular episodes, Season 2, Episode 4: Indexing for Performance, has resonated with listeners. In this episode, we break down the …

The Stedman SQL Server Podcast: A Deep Dive into SQL Server Performance Read more »