SQL Server 2014: Partition Improvements

SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild.  This will greatly increase enterprise application availability by reducing maintenance downtime impact.

The two new features are:

  • Managed Lock Priority: This allows you to manage the priority of table locks acquired by partition SWITCH and Online Index Rebuild (OIR), thereby allowing you to mitigate any negative performance impact of these locks on the primary workload on the server.
  • Single Partition Online Index Rebuild – This features allows you to rebuild indexes online for individual partitions, thereby increasing application uptime.  This is great for large partition tables.

More Info:

Exploring Partition-Level Online Index Operations in SQL Server 2014 CTP1

Improved Application Availability During Online Operations in SQL Server 2014

Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server 2014, SQLServerPedia Syndication. Bookmark the permalink.

Comments are closed.