Author: Steve Stedman

By Posted on Posted in Uncategorized

Finding Peace of Mind with SQL Server Managed Services As the owner or manager of a business that relies on SQL Server for critical data management and operations, the thought of your SQL Server encountering issues during the off-hours can be a significant source of stress. The fear of waking up to a server crash, data loss, or performance issues is enough to keep anyone up at night, questioning if their SQL Servers are properly taken care of. This concern …

Sleep Better With Our SQL Server Managed Services Read more »

By Posted on Posted in Uncategorized

Some people say I am obsessed with Join Types, they may be right, you can decide. Todays featured join product is the Joins Shower Curtain. Joins Shower Curtain Start you day out right with a shower and learn some SQL Join Types while you are there. Shower Curtain Impress your friends, and improve your knowledge about joins with this shower curtain. Other Join Products Don’t miss out, get yours today! Coffee Mug Notebook Shower Curtain T-Shirts Drawstring Bag Hats Join …

Learn SQL In The Shower Read more »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

Cut Costs Without Compromising Quality: Outsource Server Maintenance with Managed Services and Watch Your Savings Grow Welcome back, fellow data enthusiasts! Today, we’re diving into a topic that’s not only crucial for your business but also a game-changer in the world of database management: outsourcing server maintenance with Managed Services. At Stedman Solutions, we understand the importance of efficiency, reliability, and, above all, cost-effectiveness when it comes to managing your Microsoft SQL servers. Why Outsource SQL Server Maintenance? Let’s face …

Cut Costs Without Compromising Quality Read more »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

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 »

By Posted on Posted in Uncategorized

Stedman Solutions introduces, Peace of Mind Month, granting you satisfaction and reassurance for your SQL Server through Managed Services. The month of March is “Peace of Mind Month” for us at Stedman Solutions. In the dynamic landscape of technology, the ever-evolving intricacies can be a labyrinth for many. Business leaders often confess, “I lack the knowledge to maintain our database.” Recognizing this common concern, Managed Services emerges as the beacon of expertise, bridging the knowledge gap to ensure not only …

March is Peace of Mind Month Read more »

By Posted on Posted in Files and IO

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Resolving High Virtual Log File (VLF) Count in SQL Server Introduction In the world of SQL Server performance tuning, one often overlooked yet critical aspect is the management of Virtual Log Files (VLFs) within the transaction log. A high count of these VLFs can lead to a variety of issues affecting the overall health and performance of …

Resolving High Virtual Log File (VLF) Count Read more »

By Posted on Posted in Uncategorized

Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the Blocking Query Monitor. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health Read more »