SharePoint 2013 Search Database Part 1

SharePoint 2013 Search architecture drastically change, as earlier in FS4SP 2010 we have 2 search applications “FASTContentSSA” and “FASTQuerySSA” and 7 total database in use.

Following are the List of DB (FS4SP)

1. FASTContentSSA
• Search Service Application DB
• Search Service Application Crawl Store DB
• Search Service Application Property Store DB
2. FASTQuerySSA
• Search Service Application DB
• Search Service Application Crawl Store DB
• Search Service Application Property Store DB
3. FASTSearchAdminDatabase: Fast Search Admin Database 

In SharePoint 2013 search has only 1 Search Service application and 4 database in use. No property store database need any more, now the properties are directly stored inside the index component and all the index directly indexed to the physical system where FS4SP data comes from database as well as from the File system now data directly stored and indexed/ retried from the Physical disk because of this performance increase and search experienced improve.

Following are the list of DB (SharePoint 2013).

1. Crawl DB
• Used by Crawl component to determine where to crawl.
2. Link DB
• Location of items
• Row Usage information 
3. Analytic Reporting DB
• Extract and Processed usage information 
4. Search Administrator DB
• Configuration data for SharePoint Search

Crawl Database: So the crawl component is stage less and we know that the crawl component can be increased depend upon the search topology for large corpus of data. Crawl database used by the crawl component to determine where to crawl the contents. 

 
Download  SharePoint 2013 All Search Related Database Documentation

Following are the list of tables available in Crawl Database. 

1. MSSChangeLogCookies: This table keeps track of the last change that the crawler processed for each content database. 
2. MSSBatchHistory: The Office Server Search gatherer crawled documents in batches, It is creates a batch ID each time and it loads documents from the crawl queue into SQL, these BatchIDs are stored in MSSBatchHistory Table. 
3. MSSConfiguration: Store the SharePoint current as well as the version id of the search. 
4. MSSCrawlComponentsLocal: display this list of all crawl components that are available in the current search topology. 
5. MSSCrawlURL -. MSSCrawlURL contain information contains Crawl log information gathered during a crawl. 
6. MSSCrawlURLLog - MSSCrawlURLLog contain information contains Crawl log information gathered during a crawl. 
7. MSSCrawlHistoryLocal: Store the crawl history information. 
8. MSSCrawlHostList: Store the list of  crawled host name and it information.
9. MSSCrawlHostsLog: Store the crawl history Logs. 
   
10. MSSCrawlLinks: Store the crawl links Information. 
11. MSSCrawlLinksLog: Store the Log of the crawl link.
12. MSSCrawlPostponedQueue: Store the pause crawl postponed queue information.
13. MSSCrawlQueue: The “MSSCrawlQueue” table is the queue for those items that are going to be crawled. 
14. MSSCrawlReportCrawlErrors : tables contains the error during the crawl items. That error might be the ‘Access denied’ error or any other 
15. MSSCrawlURL : The MSSCrawlURL table contains the URL of that need to be crawl and crawler grab the URL form the MSSCrawlqueue table. Store the type of Data that crawled it may be a “People search” , “Intranet” and “SharePoint Site”. URL stored into “Access URL” pattern sts4://abcuniversity/siteurl=/siteid={0c3a0f00-a56e-4d4e-b2c8-2d9235189c87}/weburl=/webid={41d8e4d7-d707-4c31-a9a1-195fb4bef83e}/listid={d8411a05-f155-4728-8316-898c40bbfd53}/folderurl=Graphic Design/itemid=28 the Above string contains the server host name, Site URL , SiteID, weburl, webid, listid, and folderurl and itemid. this pattern only for SharePoint content source. 
16. MSSCrawlURLReport: Crawl Logs are in table called MSSCrawlUrlReport in Crawl Store db
17. 
18. MSSDocIDsAvailable: Store the total count of the document. 
19. MSSDocIDsDeleted: Store the delete doc ID and time.
20. MSSDocMultipleUpdatesLog: 
21. MSSNextDocID : Store the next position of  doc id. 
22. MSSOrdinal: 
23. MSSRowOrdinal: Store the row ordinal number.
24. Versions: