In reading the whitepaper: Online Indexing Operations in SQL Server 2005 it says:
The online index build process can be roughly divided into three phases:
The duration of the preparation and final phases is usually short and is independent of the size of the data.
Assuming I am building a new non-clustered index in SQL Server 2008 (online), is there a way to see how how much time was spent during an online index build for the Final Phase?
I've tried looking at the Profiler EventClass: "Progress Report: Online Index Operation Event Class", but it appears that the Final phase begins after the EventSubClass "7 - Done" has been sent to profiler
(Tested by holding an IX lock on the table during the Build Phase of the index build and seeing the thread waiting for the IS lock to be converted to the S lock on the table).