Month: December 2023

By Posted on Posted in Uncategorized No Comments

You can download the free trial of Database Health Monitor at http://DatabaseHealth.com/download2. The Risks of Storing User Tables in MSDB: Insights from Database Health Monitor When managing SQL Server environments, it’s crucial to understand best practices and potential pitfalls. One such pitfall is the storage of user tables in the MSDB database. While it might seem convenient or harmless, this practice can lead to several issues. In this post, we’ll explore why putting user tables in MSDB is a bad …

The Risks of Storing User Tables in MSDB Read more »

By Posted on Posted in Uncategorized No Comments

Ready to optimize your SQL Server’s performance? Contact Stedman Solutions, LLC today for a comprehensive health assessment. Let us help you turn your data into your most powerful business asset. How a SQL Assessment with Remediation Can Enhance Your SQL Server’s Health and Reliability When it comes to maintaining a robust, efficient, and secure SQL Server environment, regular assessments coupled with thorough remediation strategies are not just beneficial; they are essential. At Stedman Solutions, LLC, we’ve seen firsthand how a …

Enhancing SQL Server Health and Reliability Read more »

By Posted on Posted in Uncategorized No Comments

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. Identifying and Removing Leftover DTA Tables The Database Health Monitor tool offers a Quick Scan Report feature to help identify these leftover DTA tables. If you’re not actively using the Database Tuning …

Leftover DTA Tables Read more »

By Posted on Posted in Uncategorized No Comments

Enhancing SQL Server Performance with Cost Threshold for Parallelism In the world of SQL Server performance tuning, a critical factor is the efficient utilization of parallelism. This is where the “Cost Threshold for Parallelism” (CTFP) setting in SQL Server comes into play. CTFP is an essential configuration parameter that influences how SQL Server executes query plans in parallel, offering a balance between the benefits of parallelism and its potential overhead. Understanding Cost Threshold for Parallelism CTFP determines the minimum cost …

Cost Threshold for Parallelism Read more »

By Posted on Posted in Files and IO No Comments

Unlocking SQL Server Performance: The Impact of Slow IO on TempDB and How Stedman Solutions Can Help I’ve seen a myriad of performance issues that can hamstring an otherwise well-optimized system. One critical area often overlooked is the performance of the TempDB database, particularly how slow IO for its data and log files can drastically impact the overall performance of your SQL Server. The Role of TempDB in SQL Server Performance TempDB is a workhorse in SQL Server. It’s used …

The Impact of Slow IO on TempDB Read more »

By Posted on Posted in Files and IO No Comments

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 …

Discovering the Hidden Impact of Large SQL Server Error Log Files Read more »

By Posted on Posted in Files and IO No Comments

SQL Server Assessment: The Importance of Monitoring TempDB Growth As a seasoned expert in SQL Server since 1990, specializing in performance tuning, I’ve come to understand the critical role of TempDB in SQL Server’s functionality. Today, I want to delve into the importance of monitoring TempDB growth, a key aspect among the 150+ standard checks we perform at Stedman Solutions during our comprehensive SQL Server assessments. Why TempDB Matters TempDB, a system database in SQL Server, is essential for storing …

SQL Server Assessment: Monitoring TempDB Growth Read more »

By Posted on Posted in Wait Stats in SQL Server No Comments

Need help understanding Wait Statistics SQL Server, try a free no risk 30 minute consultation with Steve Stedman. SQL Server wait statistics are a critical aspect of performance monitoring and tuning in Microsoft SQL Server. They provide invaluable insights into what SQL Server is waiting on, which is crucial for identifying performance bottlenecks. Understanding and analyzing these wait statistics can significantly enhance database performance. What are SQL Server Wait Statistics? Common Problematic Wait Types Need help with this, try a …

Understanding SQL Server Wait Statistics Read more »

By Posted on Posted in Uncategorized No Comments

In the intricate realm of database management, a significant challenge that often flies under the radar is the effective management of indexes. While these indexes can be a boon to query performance, an overabundance can hinder operations like inserts, updates, and deletes. This blog post delves into the nuanced world of index management, offering strategies to trim the unnecessary without destabilizing your system. Need help with this, try a free no risk 30 minute consultation with Steve Stedman. Navigating the …

The Art of Balancing Index Management in Database Performance Optimization Read more »