Author: stevestedman

Identifying TempDB Bottlenecks with Database Health Monitor Reports SQL Server’s TempDB is a crucial system database that supports temporary storage needs for the SQL Server instance, including temporary tables, table variables, and work files necessary for sorting and query processing. However, TempDB can become a performance bottleneck if not properly managed, especially in high transaction environments. Fortunately, tools like the Database Health Monitor offer insightful reports, such as TempDB IO by Hour, TempDB Usage by Hour, and TempDB High Usage, …

Identifying TempDB Bottlenecks with Database Health Monitor Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding SQL Server CPU Utilization When working with SQL Server, you might encounter situations where it seems not to utilize all available cores or is capped at a maximum of 50% CPU load. There are several reasons why this might happen. Here’s an in-depth look into common scenarios and settings that can lead to such behavior: 1. Max Degree …

Not Using All Cores Read more »

Strategically Managing SQL Server Growth: Balancing Expansion and Costs As businesses flourish and evolve, the underlying data infrastructure must adapt accordingly. SQL Server, serving as a cornerstone for numerous organizations’ IT ecosystems, is no stranger to this evolution. While growth signifies success, it concurrently introduces increased complexity and, inherently, elevated costs. Through my extensive journey with SQL Server spanning decades, I have observed a common hurdle organizations encounter: managing the financial burden that accompanies the expansion of their SQL Server …

Managing SQL Server Growth Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Why a Misconfigured Resource Governor on SQL Server Can Have Bad Performance Impacts A misconfigured resource governor in SQL Server can have significant adverse impacts on performance for several reasons: Inefficient Resource Distribution: The resource governor is designed to manage SQL Server workloads by distributing server resources among different groups based on their needs. If it’s misconfigured, critical processes …

Resource Governor Configuration Read more »

Three Fantastic Ways to Master SQL Server Join Types Hey there, SQL enthusiasts and database professionals! It’s Steve Stedman from Stedman Solutions, LLC. Today, I’m excited to share with you three incredible ways to enhance your understanding of SQL Server join types. Whether you’re a beginner or looking to polish your skills, we’ve got something just for you! 1. Grab Your Free Join Types Poster First up, we’re offering a FREE downloadable poster that visually breaks down SQL join types. …

Three Fantastic Ways to Master SQL Server Join Types Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Security Risks of SQL Server Agent Jobs at Startup Having SQL Server Agent jobs run at startup poses several security and operational risks. It’s important to understand the context and the specific requirements of certain components, like replication, which might necessitate startup jobs. Security Risks: Elevated Permissions: Jobs running at startup might require higher permissions than regular operations, potentially …

SQL Server: Startup Jobs Security Risks Read more »