You can’t see the same thing using the dmws in the Online Index Create Rebuild process. When we take backup, we can see the percentage of backup using dmws and we have a chance to guess when it will end. So, it was really ONLINE with SQL Server 2012.Īnother shortcoming of the online Index Rebuild process is that we cannot see the percentage of the process. With SQL Server 2012, we are able to do this. The rebuild process we initiated lock the queries, and after a few minutes the phone rang. In SQL Server 2008, I couldn’t perform online rebuild indexing during business hours. However, according to my personal experience, it is not really online until SQL Server 2012. The online rebuild feature came with SQL Server 2005 to prevent the application from being affected while rebuilding the indexes.
0 Comments
Leave a Reply. |