Skip to content

Stedman Solutions

About Stedman Solutions

Stedman Solutions, LLC, is a premier provider of SQL Server consulting and managed services, specializing in performance tuning, disaster recovery, and database health management. Founded by Steve Stedman, a veteran in the SQL Server industry with over 30 years of experience, the company is dedicated to helping organizations optimize their database environments. Stedman Solutions is known for its deep expertise, personalized approach, and commitment to delivering results that ensure reliability, scalability, and top-notch performance.

Comprehensive SQL Server Managed Services

The cornerstone of Stedman Solutions is its SQL Server Managed Services, a comprehensive offering designed to meet the needs of businesses with mission-critical databases. These services include continuous monitoring, regular maintenance, and proactive problem resolution. With a team of U.S.-based SQL Server experts, most with over 20 years of experience, Stedman Solutions ensures your SQL Server environment remains healthy and secure. Unlimited support during business hours, along with optional 24/7 coverage, ensures that clients receive immediate attention when issues arise.

Performance Tuning and Optimization

Stedman Solutions has built a reputation as an industry leader in SQL Server performance tuning. By analyzing server workloads, query performance, and resource usage, the team identifies bottlenecks and implements strategies to optimize database efficiency. Whether it’s reducing query execution time, fixing fragmentation issues, or implementing missing indexes, Stedman Solutions helps clients achieve faster and more reliable database performance. Organizations that partner with Stedman Solutions often see significant improvements in application response times and overall system stability.

Expertise in Disaster Recovery and Corruption Repair

Database corruption and unplanned outages can be devastating to any organization. Stedman Solutions specializes in handling these critical issues, offering expertise in SQL Server disaster recovery and corruption repair. With extensive experience solving some of the most challenging database corruption cases, the team ensures minimal data loss and rapid recovery. Clients benefit from peace of mind, knowing their databases are protected and that expert help is always available when disaster strikes.

A Trusted Partner for SQL Server Success

Stedman Solutions is more than a consulting firm; it’s a trusted partner for businesses seeking to maximize the value of their SQL Server investment. By combining cutting-edge tools like Database Health Monitor with unparalleled SQL Server expertise, the company delivers comprehensive solutions tailored to each client’s unique needs. Whether you need ongoing support, expert advice, or one-time project assistance, Stedman Solutions is the go-to provider for SQL Server management and optimization. Learn more about their services at Stedman Solutions Managed Services and discover how they can transform your database operations.

Statistics IO for Performance Tuning in SSMS

Statistics IO and Statistics Time is another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks.

Have you ever wanted to know exactly how long it took for a query to run? Have you ever wondered how many I/O reads or writes were caused by your query? With Statistics IO and Statistics Time you can understand both of these.

Statistics IO for Performance Analysis

This post is on using statistics IO to analyze query performance. There is another post on using Statistics Time for performance tuning.

I usually prefer to use Statistics IO over Statistics Time because the Statistics IO option gives better details on what exactly the query is doing.

Let’s take the following query as an example:

Read More »Statistics IO for Performance Tuning in SSMS

Database Health Monitor – Historic Waits

With the recent release of Database Health Monitor Version 2.0 I have decided to focus on of blogging about the features and benefits of the Database Health Monitor application. There are some incredibly valuable features that are often overlooked. The purpose of this blog series is to present some of the features of the product.

If you haven’t tried Database Health Monitor, you can download it at http://DatabaseHealth.com/download. It is completely free.

Historic Waits

The Historic Waits section of Database Health monitor is in my opinion the single most valuable part of the entire product. Other vendors sell products similar the Historic Waits feature for $1500 to $2000 per SQL Server instance, making it cost prohibitive for many.

The way that Historic Waits works is that it installs a small monitoring database on a SQL Server, that can be the same SQL Server you are monitoring, or it can be a separate SQL Server just to keep track of performance.

Over time data is collected in this monitoring database that allows you to then step back in time to see what was happening with the SQL Server at a specific point in time. For instance, if you have Historic Monitoring enabled, if someone comes to you and says “The SQL Server was slow and having problems at 2:00am yesterday”, you have the ability to track down what was happening at that point in time.

The main Historic overview page shows Waits, Plan Cache Hit Ratio, Page Life Expectancy and CPU Load over time.

HistoricOverview1

Read More »Database Health Monitor – Historic Waits

SQL Saturday Denver

This year the Denver SQL Saturday is being held on September 19th.

SqlSatDenver

I believe it has been 2 years since I attended SQL Saturday in Denver.  Since the last time I was at SQL Saturday Denver, my employment has changed. Previously I was employed as a full time employee at a local company. Now I am a freelance database consultant at my own consulting firm, Stedman Solutions, LLC. The new role gives me more freedom to decide which events I am going to attend, and SQL Saturday Denver is certainly on my list.

Read More »SQL Saturday Denver