Press "Enter" to skip to content

ABORT_AFTER_WAIT on Index Rebuilds and the Error Log

Published 2024-05-21 by Kevin Feasel

Tom Zika performs an experiment:

In SQL Server, using the KILL command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD command with the WAIT_AT_LOW_PRIORITY option also log its actions in the error log?

Tom does violate Betteridge’s Law of Headlines, but you should read the post regardless.

Published in Error Handling, Indexing and Locks, Blocks, and Deadlocks

2 Comments

  1. Tom
    Tom 2024-05-21

    I did that on purpose. Thank you for noticing!

    • Kevin Feasel
      Kevin Feasel 2024-05-21

      You subverted everybody’s expectations along the way.

Comments are closed.