Performance Tuning

SQL Server MAXDOP: Why Installation Defaults Are Just the Starting Point – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server MAXDOP: Why the Installation Default Is Just the Starting Point By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 25–30 min A production SQL Server is built. The DBA […]

SQL Server Deadlock Alerts: Why They Do Not Fire and How to Fix Them – SQLYARD Leave a Comment / Articles, DBA Checklist / By SQLYARD SQL Server Deadlock Alerts: Why They Do Not Fire and How to Fix Them By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 20–25 min You set up

Automatic Plan Correction: How SQL Server Detects and Fixes Query Regressions – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Automatic Plan Correction: How SQL Server Detects and Fixes Query Regressions By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 20–25 min Query plan regressions are one of the most frustrating

SQL Server Index Tuning: From Basics to AI-Assisted Recommendations in 2026 – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server Index Tuning: From Basics to AI-Assisted Recommendations in 2026 By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 45–55 min Indexes are the single most impactful tool available to

How to Read SQL Server Execution Plans: A Complete Guide from Beginner to Advanced – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD How to Read SQL Server Execution Plans: A Complete Guide from Beginner to Advanced By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 45–55 min Most SQL Server

Performance Tuning

SQL Server system_health Alerts: Deadlock Capture, Long Waits, I/O Warnings, and More – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD SQL Server system_health Alerts: Deadlock Capture, Long Waits, I/O Warnings, and More By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Compatibility: SQL Server 2012 and later. The

Understanding Long Sync IO in SQL Server: Scheduler in Nonpreemptive Mode Longer Than 1000 ms – SQLYARD Leave a Comment / Articles, Performance Tuning, High Availability / By SQLYARD Understanding Long Sync IO in SQL Server: Scheduler in Nonpreemptive Mode Longer Than 1000 ms By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read:

In-Memory OLTP (Memory-Optimized Tables) in SQL Server: A Complete Guide – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD In-Memory OLTP (Memory-Optimized Tables) in SQL Server: A Complete Guide By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 25–30 min SQL Server 2016 through 2025 · Enterprise and Developer Edition

Smarter Parallelism in SQL Server 2025: DOP Feedback Explained – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Smarter Parallelism in SQL Server 2025: DOP Feedback Explained By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 14–17 min SQL Server 2025 · Azure SQL Database · SQL Database in Fabric

Understanding Heaps in SQL Server: Troubleshooting, Tuning, and When to Rebuild or Index – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Understanding Heaps in SQL Server: Troubleshooting, Tuning, and When to Rebuild or Index By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 14–17 min A heap is a

Understanding and Cleaning Up Overlapping Indexes in SQL Server – SQLYARD Leave a Comment / Articles, DBA Checklist, Scripts / By SQLYARD Understanding and Cleaning Up Overlapping Indexes in SQL Server By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Compatibility: All scripts work on SQL Server 2017 and later. Script

SSMS v22 Query Hint Recommendation Tool: A Practical Guide for SQL Server DBAs – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SSMS v22 Query Hint Recommendation Tool: A Practical Guide for SQL Server DBAs By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 12–15 min SSMS v22 · SQL

Exploring fn_dblog(): The Undocumented SQL Server Function That Reads the Transaction Log – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Exploring fn_dblog(): The Undocumented SQL Server Function That Reads the Transaction Log By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 12–15 min SQL Server keeps a detailed record

SQL Server Transactional Replication Performance Tuning: Log Reader and Distribution Agent – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server Transactional Replication Performance Tuning: Log Reader and Distribution Agent By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 18–22 min Transactional replication has powered SQL Server reporting environments,

Investigating Serial vs Parallel Executions in SQL Server with Query Store – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD Investigating Serial vs Parallel Executions in SQL Server with Query Store By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 15–18 min One of the most common causes of query

SQL Server TempDB Files: How Many, Why, and When to Add More – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server TempDB Files: How Many, Why, and When to Add More By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 12–15 min SQL Server 2016 through 2025 ·