SQL Server Performance

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 20, 2010.

  1. Anonymous New Member

    The question is tricky as the answer too! Online index operation (Enterprise Edition specific) is the new addition in SQL Server 2005, the simple operation behind the scenes will be preparation, build and final, it is possible to perform the concurrent online index DDL operation on the same table or views when you are creating multiple nonclustered indexes (new) and in same case of reorganizing such nonclustered indexes. But you cannot simply create another index ONLINE when another index online...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/07/20/sql-server-database-maintenance-how-to-find-out-the-execution-duration-of-online-index-build-operation.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9338" width="1" height="1">

Share This Page