SQL Improvements: Numerous SQL Server improvements to make SharePoint faster and also SharePoint will now support SQL Server 2012 from back end.
Scale and performance improvements are evident across SharePoint Server 2013 Preview, with depth that extends to the database layer. Database improvements in SharePoint Server 2013 Preview take advantage of enhancements and capabilities through SQL Server 2008 R2 SP1, including:
- Conforming to Microsoft SQL Azure™ compliance criteria.
- Removing redundant and unused tables and indices to track links
- Reducing I/O operations while browsing document libraries.
- Using SQL sparse columns to simplify SharePoint database schema and optimize data access.
- Improving large list dependencies.
SQL Server 2012
SQL Server 2012 contains a new feature called AlwaysOn Availability, which is a high-availability, disaster recovery solution that can be used when using SharePoint 2013 with SQL Server 2012. In addition to the AlwaysOn Availability, SQL Server 2012 also has reduced input/output (I/O) when browsing libraries, which will improve performance in SharePoint 2013.
Seven SharePoint 2010 databases have been deprecated in SharePoint 2013, but there are five new databases added to SharePoint 2013. The databases that have been removed include four project related databases: Project Publish, Project Archive, Project Draft, and Project Reporting. These databases will be replaced by a single database called Project Service.
The Search Property Database has also been removed, but in its place you will find a Links Store Database associated with the Search Service Application. The Search Service Application Analytics Reporting Store Database stores the information that was formerly stored in the Web Analytics Report and Web Analytics Staging databases, meaning the functionality of the Web Analytics Service Application has been integrated into SharePoint Search.
The five new databases are:
Search Service Application Links Store Database Library
Search Service Application Analytics Reporting Store Database
App Management Service Database
Translation Service Database
Come back soon to learn about New features in SharePoint 2013 – Part 3 (Cache Service)