Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

What are the differences between index databases and property databases in SharePoint2010 search?

share|improve this question

3 Answers 3

up vote 1 down vote accepted
  • Property Database: Managed properties and security descriptors for search results are not stored in the physical index files. Instead, they are efficiently stored in a database. Query servers typically satisfy a query by retrieving information from both the index file and the property database.
  • Index Database: store indexed content.

In order to learn SharePoint 2010 Search Terminology, please check-out http://www.microsoft.com/downloads/en/details.aspx?familyid=920E8C04-E8A6-4079-8B17-F3FB070FDF0D&displaylang=en

share|improve this answer

Here is a quick overview. There is a ton out there on this subject.

link

share|improve this answer

Here is an additional link: http://technet.microsoft.com/en-us/library/cc678868.aspx

The index database is called "Crawl database" it stores the state of the crawled content together with the crawl history. In the "Property database" you will find metadata related to that content (like permissions and properties).

As a recommendation (if you plan to scale out): Separate property and crawl db's to their own storage to lower I/O load. In case you are crawling and quering at once, there is a heavy load on the sql servers. Each query action will rely hefty on the property db- a parallel full crawl that runs for hours or even days will bring your sql under pressure.

If you can do your full crawls at night and let the users query over the day, you should be fine without the seperation of the db.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.