SharePoint 2013 Search Database Part 1

By -
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. 




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
  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: 

Comments

Post a Comment

Popular posts from this blog

SharePoint RPC Protocols Examples Using OWSSVR.DLL

By -
Image
What is SharePoint RPC Protocols? Part 1 This reference includes information about the methods and usage of SharePoint Foundation Remote Procedure Call (RPC) protocol. This protocol can be used in Win32-based applications or in ASPX applications to make HTTP POST requests to the server. Methods in this protocol that do not modify the contents of the database can also be used in URL protocol to make HTTP GET requests. Definition taken from http://msdn.microsoft.com/en-us/library/ms448359.aspx You will find the OWSSVR.DLL in SharePoint 2010 Server Physical Path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI and MOSS C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI OWSSVR.DLL List of commands DialogView  Display ExportList GetProjSchema GetUsageBlob HitCounter RenderView To read more about the OWSSVR.DLL command Please read the URL Protocol from Microsoft Blog having a URL http://msdn.microsoft.com/en-us/
Read more

Send Email using SharePoint Rest API

By -
We have a requirement to send email vai SharePoint Rest API. We dig and find the below solution to send email using SharePoint API. Point Must be remember End point " /_api/SP.Utilities.Utility.SendEmail " end point to send email.  In JSON __metadata we used the type " SP.Utilities.EmailProperties ". The User / Group must have a read permission for particular site. where we placed this site code. JS Dependency  JQuery Code URL:  https://gist.github.com/BasantPandey/05189832546f2c6cc0bd008fcfec3264#file-sharepointsendemail-js Code  var Email = function (){ // Email Either email groupname or email address var from = ' abc.yahoo.com ' , to = ' abc.yahoo.com ' , cc = ' abc.yahoo.com ' , subject = ' My Email Subject ' ; this . options = this . options || {}; this . options [ ' fromEmail ' ] = this . options [ ' fromEmail ' ] || {}; this . options [ ' toEmail &
Read more

Query suggestions in SP 2013 Using Rest API (/_api/search/suggest)

By -
Image
SharePoint Query suggestions: In this post I am going to share with you code snippets to implement the query suggestion in custom text box. Below are the dependency files  1. Jquery UI : http://code.jquery.com/ui/1.10.0/jquery-ui.js 2. Jquery AutoComplete CSS: http://code.jquery.com/ui/1.10.0/themes/base/jquery-ui.css http://code.jquery.com/ui/1.10.0/themes/base/jquery.ui.autocomplete.css 3. JQuery: http://code.jquery.com/jquery-1.8.3.js Query Suggestion Parameter: Here is the post http://blogs.msdn.com/b/nadeemis/archive/2012/08/24/sharepoint-2013-search-rest-api.aspx that specified the detail query suggestions parameter list. Implementation: I have two vertical examples. 1. People Vertical 2. Everything Vertical I wanted to display the query suggestions on TeamSite pages although my search is configured in one of our serach center, so when user search for a particular term and it contains in the search query completion list t
Read more