Track UPDATE progress for a SQL Server query

This is kind of an inexact science, but while an update is running, the rows column will eventually start counting down to match rowmodctr. When these two columns begin getting close to the same value, the update is almost finished. Run the query multiple times to gauge progress.

select name, rows, rowmodctr
from sysindexes with (nolock)
where id = object_id('[dbo].[TABLE_NAME]')
Copied!

Use your own input

If you have values you'd like to use instead of the provided variables, type or paste your data into the variable inputs below. If Javascript is enabled, your text will automatically be added to the command and you can click to copy.