INSERT timeout during online index rebuild

990 Views Asked by At

Is there a way to prevent SQL INSERT timeouts during SQL Server index rebuild/reorganize operations? We are using NHibernate, command timeout set at 10 minutes, SQL Server 2008 R2, index rebuild is being done online.

1

There are 1 best solutions below

7
On BEST ANSWER

Hm, no. Well, yes. If you do an online index rebuild then the table is still accessible. Requirement: ENTERPRISE edition.

What is the difference between OFFLINE and ONLINE index rebuild in SQL Server? has more information on the difference and requirements.