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
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.
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.
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 !
Written by Sneha Gopal
She comes with 4 years of experience in content management and have worked with brands from the US and UK. An enthusiastic content crafter, she loves travelling and learning about new Microsoft Technologies.