Author: stevestedman

By Posted on Posted in SQL Server Consulting Services, SQL Server Corruption No Comments

How to Run DBCC CHECKDB – a beginners guide Ensuring the integrity of your SQL Server databases is essential to maintaining a healthy and reliable system. One of the most powerful tools for this purpose is DBCC CHECKDB. In this blog post, we’ll explain how to run DBCC CHECKDB, why it’s critical, and best practices for using it. What Is DBCC CHECKDB? DBCC CHECKDB is a Database Console Command that validates the structural and logical integrity of a SQL Server …

How to Run DBCC CHECKDB Read more »

By Posted on Posted in SQL Server Performance Tuning No Comments

Understanding SQL Server Cost Threshold for Parallelism When tuning SQL Server for performance, one important configuration setting is the Cost Threshold for Parallelism. This setting directly affects when SQL Server decides to execute a query in parallel, potentially speeding up large operations or, if misconfigured, overloading system resources. In this post, we’ll explore what the Cost Threshold for Parallelism is, how it works, and best practices for configuring it in your SQL Server environment. What is Cost Threshold for Parallelism? …

SQL Server Cost Threshold For Parallelism Read more »

By Posted on Posted in SQL Server Consulting Services No Comments

What is involved with a SQL Server Performance Assessment from Stedman Solutions A SQL Server Performance Assessment from Stedman Solutions is designed to uncover and resolve issues slowing down your SQL Server. Our in-depth analysis identifies performance bottlenecks and provides actionable recommendations to enhance the speed, stability, and scalability of your databases. Key Components of a SQL Server Performance Assessment Benefits of a Stedman Solutions SQL Server Performance Assessment Ready to Get Started? At Stedman Solutions, our SQL Server experts …

SQL Server Performance Assessment Read more »

By Posted on Posted in Uncategorized No Comments

Exploring Episode 6 of the Stedman SQL Server Podcast: New Features in Database Health Monitor In Episode 6 of the Stedman SQL Server Podcast, we look at the latest updates to Database Health Monitor (DBHM), a free tool designed to give SQL Server users clear insights into performance, reliability, and potential issues. We cover several new features and bug fixes in this episode that enhance DBHM’s functionality, provide better diagnostics, and add even more monitoring power to your SQL Server …

SQL Podcast featuring Database Health Monitor Read more »

By Posted on Posted in SQL Server Performance Tuning No Comments

Understanding SQL Server Isolation Levels: Choosing the Right One for Your Needs SQL Server isolation levels are a crucial part of managing database transactions. They control how transactions interact with each other, particularly regarding locking behavior, data visibility, and concurrency. By adjusting the isolation level, you can fine-tune the balance between data consistency and performance to match your specific application needs. Let’s explore each isolation level in SQL Server, how they impact your transactions, and best-use cases for each. 1. …

SQL Server Isolation Levels Read more »

By Posted on Posted in Files and IO No Comments

CrystalDiskMark: How It Helps Assess SQL Server Performance When managing a SQL Server environment, one key factor that often gets overlooked is disk performance. SQL Server relies heavily on the speed and throughput of the storage subsystem for database operations, making it critical to understand and measure disk performance regularly. This is where CrystalDiskMark can be a game-changer. What is CrystalDiskMark? CrystalDiskMark is a popular, free, and easy-to-use benchmarking tool that measures the performance of your storage devices, such as …

CrystalDiskMark: How It Helps Assess SQL Server Performance Read more »

By Posted on Posted in SQL Server Classes No Comments

Understanding SQL Server Full Join vs. Cross Join: What’s the Difference? When working with SQL Server, understanding the different types of joins is crucial for building effective and efficient queries. Two commonly misunderstood joins are the Full Join and the Cross Join. Let’s break down what each join does, when to use it, and how they compare. Full Join: Including All Data from Both Tables The Full Join (or Full Outer Join) is used when you need to retrieve all …

Understanding SQL Server Full Join vs. Cross Join Read more »

By Posted on Posted in SQL Server Performance Tuning No Comments

Database Engine Tuning Advisor (DTA) in SQL Server: Understanding its Use and Risks The Database Engine Tuning Advisor (DTA) in SQL Server is a built-in tool designed to help identify potential performance improvements. It analyzes your database workload and provides recommendations like adding indexes, partitioning tables, and optimizing statistics. While it can be valuable for tuning your SQL Server environment, it also poses a significant risk of over-indexing, which can hurt performance if not managed properly. In this post, we’ll …

What is DTA? Read more »

By Posted on Posted in SQL Server Performance Tuning No Comments

Boost SQL Server Priority is dangerous and should not be used. Understanding the “Boost SQL Server Priority” Option in SQL Server Microsoft strongly advises against enabling this setting in production environments. When it comes to SQL Server Performance tuning, there are numerous settings and options to explore. One option that often sparks debate among DBAs is the “Boost SQL Priority” setting. While it sounds promising—after all, who wouldn’t want to “boost” SQL Server’s Performance?—the reality is more complex. In this …

Boost SQL Server Priority Read more »

By Posted on Posted in SQL Server Consulting Services No Comments

How to Choose a SQL Server Performance Tuning Consultant If your SQL Server is experiencing slowdowns or sluggish performance, it may be time to bring in a SQL Server Performance Tuning consultant. The right consultant can make a significant difference in getting your SQL Server back to peak performance. But with so many options available, how do you select the best one? In this blog post, we’ll cover the key criteria for selecting a SQL Server tuning expert and how …

How to Choose a SQL Server Performance Tuning Consultant Read more »