Press "Enter" to skip to content

LCK Wait Types and Index Rebuilds

Brent Ozar demonstrates index rebuild-based locking:

You’re investigating your SQL Server’s top wait stats, and you’re noticing a lot of LCK% waits. Normally, that indicates blocking and deadlocks, but you’re just not getting complaints from your end users, and you’re wondering what’s causing it.

It might be overzealous index rebuilds.

Click through for the demonstration and some practical advice.