Blog Posts
- Missing Primary Keys in SQL Server: Hidden Risks and How to Fix Them
In the world of database administration, few oversights carry as much weight as the absence of primary keys on SQL Server tables. While it might seem like a minor detail during initial setup or rapid development, this missing element can quietly undermine the stability and efficiency of even the most critical systems over time. Primary keys serve as the backbone of reliable data management by guaranteeing unique identification for every row. Without them, queries become harder …Missing Primary Keys in SQL Server: Hidden Risks and How to Fix Them Read More »
- How to Check and Update SQL Server Compatibility Levels with T-SQL
When you need to check compatibility level SQL Server after upgrading, start by reviewing the compatibility levels assigned to your databases. These settings determine which features and behaviors are available, directly influencing query performance and application stability during and after the upgrade process. Without a clear view of current compatibility levels across all databases, teams risk overlooking instances that could benefit from newer functionality or that might encounter unexpected issues. A quick and reliable method to …How to Check and Update SQL Server Compatibility Levels with T-SQL Read More »
- sys.dm_os_performance_counters: SQL Server Performance Counters Guide
In the world of database administration, keeping a close eye on performance metrics using sys.dm_os_performance_counters is vital for ensuring SQL Server instances run efficiently. This DMV helps DBAs track memory allocation, buffer management, and transaction throughput to spot issues before they impact users. One particularly useful resource comes in the form of dynamic management views that expose detailed counter data collected by the database engine. These views offer a direct window into internal operations, making it …sys.dm_os_performance_counters: SQL Server Performance Counters Guide Read More »
- How to Choose the Best SQL Server Performance Tuning Consultant
Navigating the complexities of SQL Server performance issues can be a daunting task for any organization. When your database starts to lag, impacting business operations, finding the right expert becomes critical. A skilled SQL Server Performance Tuning Consultant by Stedman Solutions can transform your system’s efficiency, but the challenge lies in identifying the best fit for your specific needs. The market is filled with consultants claiming expertise, yet not all possess the specialized knowledge required for …How to Choose the Best SQL Server Performance Tuning Consultant Read More »
- How to Run DBCC CHECKDB in SQL Server: Beginner’s Guide
Database administrators know that even the most carefully maintained SQL Server environments can encounter unexpected integrity problems. Over time, hardware issues, unexpected power loss, or software bugs can introduce subtle database corruption that may go unnoticed until it affects application performance or causes data loss. DBCC CHECKDB remains one of the most thorough and widely used commands for detecting these problems early. By examining allocation structures, index relationships, and page consistency, the command provides a clear …How to Run DBCC CHECKDB in SQL Server: Beginner’s Guide Read More »
- DTA SQL Server Risks: How to Avoid Over-Indexing with Database Engine Tuning Advisor
The Database Engine Tuning Advisor (DTA) helps avoid over-indexing risks in Microsoft SQL Server by analyzing workloads and suggesting safer index changes. At its core, DTA processes workload data such as trace files or query scripts to simulate the effects of potential modifications, including new indexes, updated statistics, and table partitioning schemes. This analysis aims to provide actionable scripts that DBAs can review and apply selectively, rather than requiring manual trial-and-error tuning for every workload variation. …DTA SQL Server Risks: How to Avoid Over-Indexing with Database Engine Tuning Advisor Read More »
- SQL Server Recovery Pending: Causes, Process and How to Fix It
SQL Server Recovery Pending state occurs when the engine detects inconsistencies after an improper shutdown and must run automatic recovery before users can access the database. The underlying recovery process replays committed transactions and rolls back incomplete ones using the transaction log. While this mechanism protects data integrity, prolonged recovery times can disrupt operations and raise questions about potential underlying problems. In the sections that follow, we examine the common triggers for Recovery Pending messages, the …SQL Server Recovery Pending: Causes, Process and How to Fix It Read More »
- SQL Server Backup Types: Choosing the Right Strategy for Storage and Recovery Needs
Protecting SQL Server databases requires more than simply scheduling routine backups. As data volumes grow and business operations become increasingly dependent on continuous availability, the choice of backup strategy directly influences both storage costs and the ability to recover quickly from failures or disasters. Different backup types offer distinct advantages and limitations. Full backups provide complete copies of the database but consume substantial space and time, while differentials and transaction log backups capture only changes since …SQL Server Backup Types: Choosing the Right Strategy for Storage and Recovery Needs Read More »
- SQL Code Smells: Heap Tables
You inherit a database and start digging through the schema. Everything looks reasonable on the surface until you notice a handful of tables with no clustered index. No obvious reason. They just never got one. In some cases they have been sitting that way for years, quietly degrading read and write performance while nobody thought to look. Heap tables are one of those code smells that tend to accumulate in the background. They do not cause … - Understanding the Log Shipping Instance Report in Database Health Monitor
Understanding the Log Shipping Instance Report in Database Health Monitor Log shipping has been a staple in SQL Server for what feels like forever, and for good reason. It’s a reliable, time-tested solution for Disaster Recovery, particularly for scenarios where you need a secondary site to ensure data availability. While some might argue that Replication or availability groups are more modern alternatives, log shipping remains a solid choice for many organizations due to its simplicity and …Understanding the Log Shipping Instance Report in Database Health Monitor Read More »
- Mastering sys.dm_os_schedulers: Optimize SQL Server Performance & CPU Usage
Diving into the intricacies of SQL Server Performance Tuning Tips tuning can be a game-changer for database administrators and developers alike. One of the most powerful tools at your disposal is the sys.dm_os_schedulers dynamic management view (DMV). This invaluable resource offers a detailed look into how SQL Server manages CPU resources through its schedulers, providing critical insights into task allocation and potential performance bottlenecks. Understanding sys.dm_os_schedulers is essential for anyone looking to optimize CPU usage and …Mastering sys.dm_os_schedulers: Optimize SQL Server Performance & CPU Usage Read More »
- Stedman SQL Server Podcast Episode 6: Latest Database Health Monitor Features & FixesWelcome to a deep dive into Episode 6 of the Stedman SQL Server Podcast, where we unpack the latest enhancements to Download Database Health Monitor Tool , a vital tool for SQL Server users seeking to optimize performance and reliability. This episode is packed with insights on new features and critical fixes that make Database Health Monitor an even more indispensable part of your database management arsenal. Whether you’re a seasoned DBA or just starting out, …
Stedman SQL Server Podcast Episode 6: Latest Database Health Monitor Features & Fixes Read More »
- SQL Code Smells: Non-Parameterized Queries
Your SQL Server is running hot. CPU is elevated, the plan cache is bloated, and queries that should be instant are taking seconds. You look at the query text and everything seems reasonable. The problem is not what the queries are doing. It is how they are being sent. Non-parameterized queries are one of the most common performance problems in SQL Server environments, and one of the easiest to overlook because the queries themselves often look … - SQL Server Performance Assessment: Boost Speed and Stability with Stedman Solutions
Are you struggling with slow database queries or unexpected downtime in your SQL Server environment? At Stedman Solutions, we understand how critical performance and stability are to your business operations. Our SQL Server Performance Assessment is a comprehensive evaluation designed to pinpoint inefficiencies and provide tailored solutions to supercharge your database performance. Through a meticulous process, we dive deep into every aspect of your SQL Server setup, from configuration settings to query execution plans. Our team …SQL Server Performance Assessment: Boost Speed and Stability with Stedman Solutions Read More »
- Database Health Monitor Features: Job History Charts, Problem Indexes & Backup Reports for SQL Server
Features in Database Health Monitor: Job History, Problem Indexes, and Backup Reports At Stedman Solutions, we are always working to make SQL Server management easier and more effective. Database Health Monitor continues to evolve with new reports and enhancements designed to help SQL Server administrators better understand what is happening across their environments. Some of the latest additions focus on three critical areas: SQL Server job activity Problematic indexes Backup visibility and reporting These new features … - SQL Server Error Logs Inaccessible: Causes, Fixes & Prevention
SQL Server error logs serve as a vital resource for diagnosing performance issues, security events, and unexpected failures within a database environment. When these logs become inaccessible, database administrators lose a primary source of diagnostic information at the exact moment it is needed most. This situation can quickly escalate routine troubleshooting into a prolonged and frustrating process. Common triggers for inaccessibility include oversized log files that exceed practical viewing limits, misconfigured file system permissions, and SQL …SQL Server Error Logs Inaccessible: Causes, Fixes & Prevention Read More »
- SQL Server Backup Strategy: Protect Data from Disaster, Ransomware & Corruption
The Ultimate SQL Server Backup Strategy: Protecting Your Data from Disaster and Corruption In today’s data-driven environments, SQL Server databases often serve as the backbone for critical business operations, making their protection against unexpected failures, data corruption, and catastrophic events a top priority for IT teams everywhere. Many organizations operate without a truly robust backup plan in place, only recognizing the gaps in their approach after an outage or integrity issue has already caused significant disruption …SQL Server Backup Strategy: Protect Data from Disaster, Ransomware & Corruption Read More »
- The Hidden SQL Server Performance Killer: Implicit Conversions
The Hidden SQL Server Performance Killer: Implicit Conversions When SQL Server Performance issues begin appearing, many companies assume the only solution is to add more hardware, increase cloud resources, or purchase additional SQL Server licenses. In reality, some of the biggest performance problems come from small development decisions that quietly consume CPU resources over time. One of the most overlooked examples of this is implicit conversions in SQL Server. Implicit conversions occur when SQL Server automatically …The Hidden SQL Server Performance Killer: Implicit Conversions Read More »
- Catching Failing Database Health Monitor Jobs
Catching Failing Database Health Monitor Jobs with Check 239 Catching Failing Database Health Monitor Jobs with Check 239 One of the most valuable aspects of Database Health Monitor is its ability to watch for issues that might otherwise go unnoticed until they become much larger problems. Check 239 is a great example of this proactive approach to SQL Server monitoring. Check 239 specifically monitors for failing Database Health Monitor jobs. Why Database Health Monitor Jobs Matter … - The Real Cost of SQL Server Management: Download Our White Paper Now
Are you aware of the true financial burden of managing SQL Server in-house? Many organizations underestimate the hidden costs that go beyond salaries, including tools, training, and the risk of costly downtime. Our latest white paper, “The Real Cost of SQL Server Management: In-House Team vs. Stedman Solutions,” uncovers the full spectrum of expenses and challenges that come with maintaining an internal database team. From hiring skilled DBAs to investing in specialized software, the expenses of …The Real Cost of SQL Server Management: Download Our White Paper Now Read More »
- Optimizing SQL Server Backups for Performance and ReliabilityOptimizing SQL Server Backups for Performance and Reliability Effective backup strategies are essential for protecting SQL Server environments from data loss while maintaining acceptable performance levels. By focusing on compression, striping, and thoughtful scheduling, database administrators can reduce backup windows and improve overall reliability without sacrificing recoverability. Backup Compression Enabling backup compression reduces the size of backup files and lowers the amount of data written to disk. This typically shortens backup duration and decreases storage requirements. …
Optimizing SQL Server Backups for Performance and Reliability Read More »
- CPU Drill-Down Feature in Database Health Monitor
CPU Drill-Down Feature in Database Health Monitor A powerful capability has arrived in Database Health Monitor, making CPU troubleshooting faster and more intuitive. For years, DBAs relied on two separate views: CPU by Database and CPU by Query. Each provided insight, but there was no direct connection between them. That changes now. The Problem: Lack of Context The CPU by Database report showed which database used the most CPU, but not why. CPU by Query listed …CPU Drill-Down Feature in Database Health Monitor Read More »
- Database Health Monitor: The Best SQL Server Monitoring Tool for Optimal Performance
In the fast-paced world of database management, maintaining peak performance for SQL Server environments is a top priority. Download Database Health Monitor for SQL Server emerges as a standout solution, offering unparalleled insights into the health and efficiency of your databases. This powerful tool is designed to empower database administrators and developers alike with the ability to proactively address issues before they impact operations. Unlike other monitoring tools that merely scratch the surface, Database Health Monitor …Database Health Monitor: The Best SQL Server Monitoring Tool for Optimal Performance Read More »
- SQL Server Data Aggregation: Master Powerful Data Insights
SQL Server data Aggregation is a game-changer for anyone looking to extract meaningful insights from vast datasets. By harnessing the power of aggregation functions, you can summarize, analyze, and transform raw data into actionable information. Whether you’re a database administrator or a business analyst, mastering these techniques is essential for unlocking the full potential of your data. At its core, data aggregation in SQL Server allows you to perform calculations like summing values, finding averages, or …SQL Server Data Aggregation: Master Powerful Data Insights Read More »
- SQL Server Performance Assessment: Boost Efficiency with Stedman Solutions
In the realm of database management, ensuring optimal performance of your SQL Server is not just a technical necessity but a business imperative. At Stedman Solutions, we recognize that a sluggish or inefficient SQL Server can hinder operations, frustrate users, and impact your bottom line. That’s why we specialize in comprehensive performance assessments designed to identify bottlenecks and unlock the full potential of your database environment. A SQL Server Optimization Assessment from Stedman Solutions goes beyond …SQL Server Performance Assessment: Boost Efficiency with Stedman Solutions Read More »
- Database Performance: How to Balance Index Management for Optimal Results
Database performance is a critical factor in ensuring that applications run smoothly and efficiently, and index management plays a pivotal role in this equation. Indexes can transform sluggish queries into lightning-fast operations by providing SQL Server with efficient pathways to data. However, the art of index management lies in finding the sweet spot—too many or too few indexes can tip the scales toward inefficiency, storage bloat, or performance bottlenecks. Striking the right balance in index management …Database Performance: How to Balance Index Management for Optimal Results Read More »
- Decoding SOS_SCHEDULER_YIELD Wait Type in SQL Server: Causes and Solutions
Learn about SOS_SCHEDULER_YIELD wait type in SQL Server: uncover causes like CPU contention and solutions for performance tuning with expert tips. This wait type surfaces when a task voluntarily relinquishes its CPU time to allow other tasks to run, a natural part of SQL Server’s cooperative scheduling model. However, when these waits become frequent or prolonged, they can point to underlying issues that degrade system performance, making it crucial to understand their implications. At its core, …Decoding SOS_SCHEDULER_YIELD Wait Type in SQL Server: Causes and Solutions Read More »
- Dangers of Removing Indexes
In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index management and discuss strategies to identify and remove unnecessary indexes without compromising system stability. The Dilemma … - How to Check Table Sizes in SQL Server Using T-SQL and Tools
Managing table sizes in SQL Server is an essential task for any database administrator looking to maintain optimal performance and efficient storage usage. Large or rapidly growing tables can lead to slower queries, increased backup times, and potential bottlenecks. In this post, we’ll explore practical methods to check table sizes using T-SQL scripts and introduce helpful tools to simplify the process. Knowing the size of your tables isn’t just about keeping track of storage; it’s about …How to Check Table Sizes in SQL Server Using T-SQL and Tools Read More »
- CrystalDiskMark: Optimize SQL Server Performance with Disk Benchmarking
Optimize SQL Server Performance Tuning Results with CrystalDiskMark, a key tool for disk benchmarking to ensure fast queries and efficient database management. The speed and efficiency of your storage system directly influence how quickly SQL Server can execute queries, manage transactions, and handle backups. Ignoring this critical component can lead to frustrating bottlenecks that impact the entire database environment. This is where a tool like CrystalDiskMark becomes invaluable. As a free and user-friendly benchmarking utility, CrystalDiskMark …CrystalDiskMark: Optimize SQL Server Performance with Disk Benchmarking Read More »
- SQL Server Trace Flag 1118: Boost TempDB Performance & Reduce Contention
In the realm of SQL Server Optimization optimization, small tweaks can yield substantial results, especially when dealing with high-traffic components like TempDB. One such tweak involves the use of Trace Flag 1118, a powerful yet often underutilized tool that can significantly reduce contention and enhance TempDB efficiency. If your SQL Server environment struggles with TempDB bottlenecks, understanding this trace flag could be a game-changer. TempDB is a critical system database in SQL Server, heavily utilized for …SQL Server Trace Flag 1118: Boost TempDB Performance & Reduce Contention Read More »
- SQL Code Smells: Implicit Conversions
You run a query against a table. The column is indexed. The statistics are fresh. And yet the query does a full scan, takes ten times longer than it should, and you have no idea why. The code looks correct. The data looks correct. Nothing looks wrong. The culprit is a single mismatched data type, and SQL Server fixed it for you without saying a word. What is an implicit conversion? Every comparison SQL Server makes … - When TempDB Grows “Up and to the Right”: How RCSI and Open Transactions Quietly Break SQL Server
When TempDB Grows “Up and to the Right”: How RCSI and Open Transactions Quietly Break SQL Server One of the most dangerous SQL Server problems is the one you don’t notice until the disk is full and production is down. TempDB is especially good at failing this way—quietly growing in the background until it suddenly becomes everyone’s problem. Recently, we were reviewing the TempDB Allocation History Report, and it perfectly illustrated an issue we’re seeing more … - Stop Guessing When SQL Agent Jobs Run: Visualizing Job History with Sortable Timeline Charts
Stop Guessing When SQL Agent Jobs Run: Visualizing Job History with Sortable Timeline Charts This blog post idea centers on a problem every SQL Server DBA has faced at some point: trying to understand when SQL Agent jobs actually run and how often they fire. It often starts with a simple question such as what runs at three in the morning, whether jobs are overlapping, or why performance slows during certain windows. The frustration quickly sets … - Proactively Manage SQL Server Disk Space with the New Disk Space Forecast Report in Database Health Monitor
Proactively Manage SQL Server Disk Space with the New Disk Space Forecast Report in Database Health Monitor As SQL Server DBAs, one of the most stressful surprises is a sudden “out of disk space” error, especially in production environments where backups, logs, and data growth can quickly fill drives. That’s why the Disk Space Forecast Report in Database Health Monitor is such a valuable tool for staying ahead of storage issues. Recently on the Stedman SQL … - Join Types Shirt
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power and versatility of JOINs. From eye-catching JOIN posters to cozy JOIN socks, and from comprehensive JOIN … - How Database Health Monitor Helps Junior DBAs Find Problems Faster
Starting out as a SQL Server DBA can feel overwhelming. There are hundreds of dynamic management views, dozens of performance counters, and no clear starting point when something goes wrong. You know the issues are there, but figuring out where to look and what matters most is often the hardest part. The challenge is not effort. Most junior DBAs are willing to dig in and learn. The real challenge is visibility. Without the right perspective, it …How Database Health Monitor Helps Junior DBAs Find Problems Faster Read More »
- SQL Server Join Types ClassWelcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power and versatility of JOINs. From eye-catching JOIN posters to cozy JOIN socks, and from comprehensive JOIN …