D
dbeavon
Guest
>> Would you agree to use online idxbuild that locks the whole table while the utility is building one of table’s indexes? Absolutely, if the outage window is reasonable (as is the case when using idxbuild with 16 cores running at 4GHz with SSD). Databases operate by locking resources as a matter of course. Locking a table is conceptually similar to locking all the records within the table. We can reword your question and ask: would you agree to allow users of a database to lock multiple records in a table for a reasonable window of time? (... and this brings to mind another key SQL Server feature - lock escalation! We have our "-L" in production at 500,000, and there have been times when this was actually needed! It would be extremely hard to imagine SQL ever taking that many locks on individual records at any one moment of time.)
Continue reading...
Continue reading...