Author: Steve Stedman

In the intricate world of SQL Server, understanding various wait types is crucial for database Performance Tuning. One such wait type, often encountered but not always well-understood, is the LCK_M_IU. This blog post aims to demystify the LCK_M_IU wait type, shedding light on its causes, diagnosis, and resolution strategies. At Stedman Solutions, we specialize in SQL Server performance tuning, and if you’re struggling with waits like LCK_M_IU, our Managed Services can help identify and resolve these bottlenecks quickly. Learn more …

Unlocking the Mystery of the LCK_M_IU Wait Type in SQL Server Read more →

SQL Server Replication Course from Stedman Solutions Are you looking to master SQL Server replication but don’t know where to start? Or maybe you’ve been tasked with setting up replication in your SQL Server environment, and it feels like a daunting task. The SQL Server Replication Course from Stedman Solutions is here to help you bridge that gap. Designed by true SQL Server specialists, this course provides hands-on learning to give you the confidence and expertise you need to handle …

SQL Server Replication Course Read more →

When it comes to managing SQL Server, monitoring and optimizing performance is a critical part of ensuring that your database environment is running smoothly. The Database Health Monitor for SQL Server is an invaluable tool for monitoring performance and identifying potential issues before they become significant problems. One of the most critical aspects of SQL Server Performance monitoring is understanding the query execution plan. The query execution plan describes how SQL Server executes a query, including which indexes and operators …

SQL Server Monitoring Tools Read more →

The Importance of a SQL Server Performance Assessment by Stedman Solutions### SQL Server Performance Assessment: The Key to Peak Database Performance Keeping Your SQL Server Running at Its Best Your SQL Server’s Performance is critical to ensuring seamless business operations, especially in today’s demanding technological landscape. Regular performance assessments are essential for maintaining efficiency, identifying potential bottlenecks, and resolving hidden issues before they escalate. With Stedman Solutions’ comprehensive SQL Server performance assessment, you can proactively optimize your database environment and …

SQL Server Performance Assessment – Stedman Solutions Read more →

For many SQL Server administrators and developers, DBCC SHOWCONTIG was once a go-to tool for diagnosing index and table fragmentation. However, Microsoft announced its deprecation over a decade ago, signaling its eventual removal in a future version of SQL Server. While it remains functional in older versions, relying on it in newer systems is no longer recommended. What is DBCC SHOWCONTIG? DBCC SHOWCONTIG is a Database Console Command (DBCC) in SQL Server designed to analyze the fragmentation of tables and …

DBCC SHOWCONTIG: A Deprecated Command in SQL Server Read more →