Understanding Search Databases in SharePoint Server

The SharePoint search architecture contains search components and database. There are essentially four types of search databases:

  • Crawl database
  • Link database
  • Analytics reporting database
  • Search administration database  

 

 Crawl database

This database stores historical information and tracking information of crawled items. It stores crawl metrics such as last crawl ID,types of update during last crawl,last crawl time,etc.

 

Link database 

Information stored by the content processing component is stored in the link database. The database stores information about search clicks i.e.the number of times people click on a search result. The information is stored unprocessed to be analyzed by the analytics processing component.

Reporting database

The results of usage analytics is stored by the analytics reporting database.Further, it also stores statistics information from the analyses. This information is used by SharePoint Server to create Excel reports that showcase different statistics.

Search administration database 

Search configuration data like crawl rules,query rules,topology and the mappings between crawled and managed properties is stored in search administration database. Further, it also stores the access control list (ACL) for the crawl component. Only one search administration database can be there per search service application.

 

To know more about SharePoint Search Database, get in touch with our experts.  Are you looking to get the most out of SharePoint and Office 365 ? Meet Dock 365, an intranet powered by SharePoint and Office 365. Enable your employees to innovate, discover, organize, collaborate, communicate and connect effectively anywhere at any time. Do more with Dock 365!

Schedule a Free Demo Now !

Free Trial

 

Overview of Search Components in SharePoint Server

Structuring the search architecture essentially depends on the fact where the user intends to use search i.e. the enterprise or  Internet sites. The search architecture consists of  search components and databases. While building the search architecture, there are different factors to be considered including fault tolerance, volume of your content, high availability, estimated amount of page views and queries per second, etc. 

An Overview of Hybrid Configuration in SharePoint Server

Is your organization planning to move existing on-premises SharePoint Server services to the cloud?Then SharePoint Server hybrid is something you should definitely know about. It provides an excellent migration path by extending high-impact SharePoint Server workloads to SharePoint Online.