Should We Defragment Indexes? - A Deep Dive into Modern Disk Architecture and I/O Performance

Explore the impact of index defragmentation on modern disk architecture and database performance in this 19-minute SQLBits conference talk. Gain insights into external fragmentation and its potential effects on I/O operations. Learn when to reconsider or limit index defragmentation practices to optimize database performance. Discover valuable information applicable to various SQL platforms, including SQL 2019, Azure SQL Database, Managed Instance, and SQL on Linux. Join speaker Rob Mandeville as he delves into database engine management, administration, monitoring, and optimization techniques.

Should We Defragment Indexes?