Win prizes like Hard Disk, Pen drives, T-Shirts etc.
for more information
SharePoint Articles ↓
SharePoint Object Model
MasterPage & Page Layout
List & Library
View All Jobs
See All News
.Net Articles ↓
Testing (QTP) Training
Request a Quote
SharePoint 2013 databases
05-Jun-2013 8:15 PM
In this post we will discuss about what are the databases in SharePoint 2013. SharePoint 2013 uses more databases to improve the performance your SharePoint server farm.
You can also check out my previous posts on:
Enable Sign in as Different User Option in SharePoint 2013
Architectural changes in SharePoint 2013
Get column names of SharePoint list using SharePoint 2010 client object model
Stores the App licenses and permissions.
Stores External Content types and Related objects.
Contains data about all SharePoint databases, all Internet Information Services (IIS) websites or Web applications, trusted solutions, Web Part Packages, site templates, and Web application and farm settings specific to SharePoint 2013
Central Administration Content:
Content database for the Central Administration site. (SharePoint_Admin_Content)
Stores all site content, including site documents or files in document libraries, list data, web part properties, audit logs, sandboxed solutions, and usernames and rights. All the data for a specific site resides in one content database. Content databases can contain more than one site collection.
Search Administration (Search_Service_Application_DB_<GUID>):
Hosts the Search application configuration and access control list (ACL) for the crawl component.
Stores and maps credentials such as account names and passwords.
Usage and Health Database:
Stores health monitoring and usage data temporarily, and also used for reporting and diagnostics.
Profile (User Profile Service Application_ProfileDB_<GUID>):
Stores and manages users and their social information.
Synchronization (User Profile Service Application_SyncDB_<GUID>):
Stores confi guration and staging data for use when profile data is synchronized with directory services such as Active Directory.
Social Tagging (User Profile Service Application_SocialDB_<GUID>):
Stores social tags and notes created by users along with their respective URLs.
Stores features and settings information for hosted customers. This database is not created by default but must be created by using Windows PowerShell or SQL Server.
Word Automation Services database (WordAutomationServices_<GUID>):
Stores information about pending and completed document conversions.
Managed Metadata Service (Managed Metadata Service Application_Metadata_<GUID>):
Stores managed meta data and syndicated content types.
Machine Translation Services database (SharePoint Translation Services_<GUID>):
Stores information about pending and completed batch document translations with file extensions that are enabled.
Project Server database (ProjectWebApp):
Stores all the data for a single Project Web App (PWA).
PowerPivot database (DefaultPowerPivotServiceApplicationDB_<GUID>):
Stores data refresh schedules and
PowerPivot usage data copied from the central usage data collection database.
PerformancePoint Services database (PerformancePoint Service _<GUID>):
Stores temporary objects and persisted
user comments and settings.
State Service database (SessionStateService_<GUID>):
Stores temporary state information for InfoPath Forms Services, Exchange, the chart web part, and Visio Services.
Check out the full in this
If You Like this Post, Please Like us in Facebook and Follow us in Twitter
Share This Now >>
I am Bijay from Odisha, India. Currently working with a reputed organization in Bangalore. I am Microsoft Office Servers and Services (SharePoint) MVP (3 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out
My MVP Profile.
view full profile
To insert images, Upload images
or you can use flickr or picasa to upload images. After that paste the image url in the editor image dialog box.
Recent SharePoint Articles
-How to delete file using Rest API in SharePoint Online Offic...
-Enable tree view in Office 365 SharePoint Online sites
-SharePoint hosted add-in error Failed to get web title Error...
-How to retrieve host web site title in add-in web in SharePo...
-How to retrieve all host web lists in add-in web in SharePoi...
See all articles
SharePoint Tag Cloud
AngularJS SharePoint (4)
Backup and Restore (13)
Business Conectivity Services (11)
CAML and LINQ (10)
Central Administration (3)
Excel Services (14)
Featurs and Event Receivers (18)
Interview Questions (11)
List and Library (125)
MasterPage and PageLayOut (24)
Moss 2007 (3)
Product Reviews (37)
REST API SharePoint (45)
SharePoint 2010 (96)
SharePoint 2013 (167)
SharePoint 2016 (46)
SharePoint 3rd party tools (2)
SharePoint Apps (52)
Sharepoint Customization (85)
SharePoint Designer (35)
SharePoint Object Model (82)
SharePoint Online and Office 365 (92)
SharePoint Search (40)
SharePoint Security (25)
Site Collection and Web Application (17)
Site Definition and Templates (15)
Video Tutorials (3)
Visual Studio (36)
WCF and Web Service (8)
Windows Azure (20)
Related SharePoint Articles
-How to add navigation link in site settings navigation page SharePoint 2013 using Visual Studio 2013?
-An unknown error has occurred. The form template has been published to the server but it can only be opened in infopath filler
-List tools tab missing SharePoint 2010
-How to get content database size using PowerShell in SharePoint 2016 and using SharePoint server object model
-SharePoint 2013 Populate Manager name using SPServices
-Enable Validation in List Definition from Visual Studio 2010 in SharePoint 2010
See all articles
Recent Article Comments
24-Mar-2017 11:02 AM
Try the most promising tool OST to PST Converter software which can recover...
24-Mar-2017 5:59 AM
Good one thanks for sharing sir
15-Mar-2017 10:47 AM
07-Mar-2017 3:55 PM
Danilo da Silva Guimarães
Thanks for sharing the information!Helped me a lot! =)Sincerely,Danilo
03-Mar-2017 6:48 AM
As a beginner,those codes are very easy to debug and outputs are straight f...
See all article comments
Subscribe by e-mail address to receive latest news and updates.