Author: stevestedman

By Posted on Posted in Uncategorized No Comments

= 2 THEN a.used_pages ELSE 0 END) * 8 AS IndexSpaceKBFROM sys.tables tINNER JOIN sys.partitions p ON t.object_id = p.object_idINNER JOIN sys.allocation_units a ON p.partition_id = a.container_idGROUP BY t.nameORDER BY TotalSpaceKB DESC; What the Query Does This query calculates: TotalSpaceKB: The total space allocated for each table, including data, indexes, and unused space. UsedSpaceKB: The space actively used by data and indexes. UnusedSpaceKB: The difference between the allocated space and the used space, representing room for growth. DataSpaceKB: The size …

Table Sizes in SQL Server – options Read more »

By Posted on Posted in Uncategorized No Comments

The Importance of a SQL Server Performance Assessment by Stedman Solutions Maintaining your SQL Server’s performance is essential in today’s fast-paced, data-driven world. At Stedman Solutions, we understand how critical your SQL Server is to your business’s success. That’s why we offer comprehensive performance assessments tailored to your environment. It all begins with a free 30-minute consultation to explore how we can address your unique SQL Server challenges and goals. Keeping Your SQL Server in Prime Condition A properly maintained …

Stedman SQL Server Performance Assessment Read more »

By Posted on Posted in SQL Server Performance Tuning No Comments

Understanding SQL Server Trace Flag 1118: Enhancing TempDB Performance When it comes to SQL Server Performance tuning, understanding and using trace flags can provide significant benefits. One particularly valuable trace flag is 1118, which can address contention issues in the TempDB database and improve performance in environments with heavy TempDB usage. Let’s dive into what Trace Flag 1118 does, when to use it, and how it can make a difference. What Does Trace Flag 1118 Do? Trace flag 1118 is …

Trace Flag 1118 Read more »

By Posted on Posted in SQL Server Classes No Comments

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 No Comments

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 No Comments

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 No Comments

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 No Comments

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 No Comments

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 No Comments

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 »