SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

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

published 663 days, 14 hours, 13 minutes ago posted by

sa 673 days, 13 hours, 59 minutes ago

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

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...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: Best Practices, event class, Indexes, online, profiler, rebuild, SQL Server, trace

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

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

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up