New features in SharePoint 2013 – Part 2 (SQL improvements)

SQL Improvements: Numerous SQL Server improvements to make SharePoint faster and also SharePoint will now support SQL Server 2012 from back end.

Data Platform

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:

  1. Project Service
  2. Search Service Application Links Store Database Library
  3. Search Service Application Analytics Reporting Store Database
  4. App Management Service Database
  5. Translation Service Database

(Thanks to Brian Alderman for the insight)

Come back soon to learn about New features in SharePoint 2013 – Part 3 (Cache Service)



About Vamshideep

SharePoint Architect
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s