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 …
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 …
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 …
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: …
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 …
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 …
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 …
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 →
Deadlocks in SQL Server can cause serious performance issues, impacting transactions and slowing down applications. To help database administrators gain deeper insights into deadlocks and resolve them more effectively, Database Health Monitor includes six powerful reports focused on deadlock analysis. These reports provide a server-wide view, per-database breakdowns, historical trends, and object-level details, making it easier to diagnose and prevent deadlocks. 1. Instance Deadlock History Report View Report This report offers a historical overview of all deadlocks that have occurred …
Discovering the Hidden Impact of Large SQL Server Error Log Files: Insights from Stedman Solutions Author: Steve Stedman, Stedman Solutions, LLC In the realm of SQL Server Performance tuning and maintenance, one often overlooked aspect is the size of the SQL Server error log files. These files, although crucial for diagnostics and troubleshooting, can grow unexpectedly large, impacting the overall performance and reliability of your SQL Server instance. At Stedman Solutions, we’ve discovered through our extensive experience that managing these …
We are ready to help. Steve and the team at Stedman Solutions are here to help with your SQL Server needs. Get help today by contacting Stedman Solutions through the free 30 minute consultation form.
Contact Info for
Stedman Solutions, LLC.
PO Box 3175, Ferndale WA 98248,
Phone: (360)610-7833
Our Privacy Policy