A weekly DBCC CHECKDB job was stopped by a terminator job, but its SPID stayed, waiting on PREEMPTIVE_OS_DEVICEIOCONTROL. Here are ways to handle that situation.
Asynchronous Statistics Updates: When They Help and When They Hurt
Evaluate asynchronous statistics updates against compile latency, data-change timing, and low-priority metadata locking in SQL Server.
Intelligent Query Processing: Checking What Is On per Database
Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.
Inline Table-Valued Functions: Parameterized Views That Stay Fast
Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.
Max Degree of Parallelism for Microsoft Dynamics CRM
Max degree of parallelism controls how many cores one query can use, and the vendor guidance for Microsoft Dynamics CRM has been 1. This post measures what parallel plans cost on a heavy and a small query. It shows a database scoped limit and the instance wide statements.
Wide Covering Indexes: The Cost of INCLUDE Everything
Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.
Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation
Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.