Author: Steve Stedman

By Posted on Posted in SQL Server Classes

SQL Server Data Aggregation: Unlocking the Power of Your Data When working with SQL Server, effective aggregation is a cornerstone of building meaningful reports, summaries, and insights. Whether you’re calculating totals, averages, or breaking down complex datasets into digestible pieces, understanding SQL Server’s aggregation tools is critical. In this blog post, we’ll explore the basics of SQL Server data aggregation and how it can streamline your data analysis processes. What Is Data Aggregation? Data aggregation involves gathering, summarizing, or transforming …

SQL Server Data Aggregation Read more »

By Posted on Posted in Files and IO

Understanding Instant File Initialization in Microsoft SQL Server When managing SQL Server, Performance Tuning often requires attention to how SQL Server handles storage and file operations. One feature that can significantly improve the speed of certain operations is Instant File Initialization (IFI). This blog post will explain what IFI is, how it works, its benefits, and considerations for enabling it in your SQL Server environment. What is Instant File Initialization? Instant File Initialization (IFI) is a feature in Microsoft SQL …

Instant File Initialization Read more »

By Posted on Posted in Uncategorized

What Does “Parallel Redo is Started for Database” Mean? If you’ve come across the phrase “parallel redo is started for database” in your SQL Server error logs or monitoring tools, you might wonder what it signifies. This phrase is tied to SQL Server’s advanced recovery process and is an important indicator of how modern SQL Server versions handle transaction log recovery in high-performance environments. This blog post dives deep into what this message means, when it occurs, and how it …

Parallel Redo is Started for Database Read more »

By Posted on Posted in SQL Server Performance Tuning

Understanding sys.dm_os_schedulers in SQL Server One of the most critical aspects of SQL Server Performance tuning is understanding how resources, especially CPU cores, are used. The sys.dm_os_schedulers dynamic management view (DMV) provides insights into SQL Server’s schedulers, which represent logical CPUs, and how they manage tasks. This post explores the details of sys.dm_os_schedulers, what it reveals about SQL Server’s internal scheduling processes, and how you can use it to troubleshoot performance bottlenecks. What is sys.dm_os_schedulers? SQL Server relies on a …

Understanding sys.dm_os_schedulers Read more »

By Posted on Posted in SQL Server Performance Tuning

Understanding MAXDOP SQL Server Settings: What They Are and How They Work In SQL Server, optimizing query performance often requires fine-tuning the MAXDOP (Maximum Degree of Parallelism) setting. If you’ve come across discussions about max degree of parallelism in SQL Server, you might wonder what it is, how it works, and why it matters. This blog post explains the essentials of MAXDOP, how it impacts query execution, and the best practices for configuring it in your SQL Server environment. What …

MAXDOP SQL Server setting Read more »

By Posted on Posted in Wait Stats in SQL Server

Understanding the SOS_SCHEDULER_YIELD Wait Type in SQL Server The SOS_SCHEDULER_YIELD wait type is one of the most commonly encountered waits in SQL Server. It indicates that a task is voluntarily yielding its CPU time to allow other tasks to execute. While it’s normal to see some SOS_SCHEDULER_YIELD waits, excessive occurrences can signal a performance bottleneck. In this post, we’ll explore what this wait type means, when it’s problematic, how to diagnose it, and steps you can take to resolve it …

SOS_SCHEDULER_YIELD wait Read more »

By Posted on Posted in SQL Server Consulting Services

SQL Health Check Report: How Stedman Solutions Can Help Optimize Your SQL Server Environment A well-maintained SQL Server environment is critical for business operations, but without regular monitoring, issues like slow queries, blocked processes, and inefficient configurations can creep in. At Stedman Solutions, we offer a comprehensive SQL health check report—also known as our Health Assessment or Performance Assessment—to identify problems, optimize performance, and provide actionable recommendations to keep your databases running smoothly. In this blog post, we’ll explore what’s …

SQL Health Check Report Read more »

By Posted on Posted in SQL Server Consulting Services, SQL Server Corruption

How to Run DBCC CHECKDB – a beginners guide Ensuring the integrity of your SQL Server databases is essential to maintaining a healthy and reliable system. One of the most powerful tools for this purpose is DBCC CHECKDB. In this blog post, we’ll explain how to run DBCC CHECKDB, why it’s critical, and best practices for using it. What Is DBCC CHECKDB? DBCC CHECKDB is a Database Console Command that validates the structural and logical integrity of a SQL Server …

How to Run DBCC CHECKDB Read more »

By Posted on Posted in SQL Server Performance Tuning

Understanding SQL Server Cost Threshold for Parallelism When tuning SQL Server for performance, one important configuration setting is the Cost Threshold for Parallelism. This setting directly affects when SQL Server decides to execute a query in parallel, potentially speeding up large operations or, if misconfigured, overloading system resources. In this post, we’ll explore what the Cost Threshold for Parallelism is, how it works, and best practices for configuring it in your SQL Server environment. What is Cost Threshold for Parallelism? …

SQL Server Cost Threshold For Parallelism Read more »

By Posted on Posted in SQL Server Consulting Services

What is involved with a SQL Server Performance Assessment from Stedman Solutions A SQL Server Performance Assessment from Stedman Solutions is designed to uncover and resolve issues slowing down your SQL Server. Our in-depth analysis identifies performance bottlenecks and provides actionable recommendations to enhance the speed, stability, and scalability of your databases. Key Components of a SQL Server Performance Assessment Benefits of a Stedman Solutions SQL Server Performance Assessment Ready to Get Started? At Stedman Solutions, our SQL Server experts …

SQL Server Performance Assessment Read more »