Online index rebuild. Is it?
While it does sound attractive to use, the online index rebuild has its specifics and it is important to know them when we perform an index maintenance. It will save our time as a DBA, if you could find the answers of question like why it takes different time to complete on every execution, if it is an online operation why a blocking occurs, how to deal with that. The new Managed lock priority for OIR in SQL Server 2014 is a great feature. It could solve some of our problems and easy create bigger ones. That’s why it needs a careful planning and a wise implementation. What does it mean, how it works, and how to implement it, what to avoid - all you need to know about online index rebuild and Managed Lock Priority you can found in this session.
Sorry, there are no downloads available for this session.
Magi Naumova is an SQL Server Architect and Consultant, speaker and trainer, Microsoft Certified Master of SQL Server 2008, SQL Server MVP, MCT, Founder of SQL Master Academy, founder and leader of the BG SQL User group. She has more than 15 years SQL Server training and consulting experience. Magi is a former member of Microsoft Services Worldwide Technical Leadership Team, а Microsoft Women worth watching http://zd.net/1lwNYKH Currently she speaks, writes, train and consult people on SQL Server. Her unique SQL Master Academy training program has helped hundreds of specialists to feel knowledgeable in their daily work or to find an inspirational career path in the world of SQL Server.
The video is not available to view online.