Export (0) Print
Expand All

Setqueryprocessoroptions: Stsadm operation (Office SharePoint Server)

Office 2007

Updated: April 28, 2009

Applies To: Office SharePoint Server 2007

 

Topic Last Modified: 2009-04-22

Sets the current values of the SharePoint Search query processor settings.

For additional information about how to manage settings to improve search results, see Manage settings to improve search results (Office SharePoint Server).

NoteNote:
The setqueryprocessoroptions operation was first introduced in Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2).

stsadm -o setqueryprocessoroptions

   -ssp <SSP name>

   [-securitytrimmingcachesize <security trimming cache size>]

   [-securitytrimmingmultiplier <security trimming overfetch multiplier>]

   [-nearduplicatemultiplier <duplicate removal overfetch multiplier>]

   [-joinmultiplier <join discard overfetch multiplier>]

   [-sdidjoinmultiplier <missing security descriptor overfetch multiplier>]

 

Parameter name

Value

Required?

Description

ssp

A valid Shared Services Provider (SSP) name, such as "SharedServices1"

Yes

Specifies the name of the SSP that is associated with the query processor.

securitytrimmingcachesize

A valid integer between 1 and 2,147,483,647

No

Specifies an increase of the w3wp process memory usage. This increases the probability of finding security descriptors needed in local cache, thus decreasing the number of roundtrips to a computer running SQL Server and the amount of data requested from a computer running SQL Server. This value should be considered if the search corpus contains a large number of different Access Control Lists (ACL).

The default value is 10,000.

securitytrimmingmultiplier

A valid integer between 1.001 and 100

No

When the multiplier is specified, it will result in more items being retrieved. This should be considered if there is a large search corpus, but each item is only accessible to a small number of people.

The default value is 2.6.

nearduplicatemultiplier

A valid integer between 1.001 and 100

No

When specified the multiplier will result in more items being retrieved. This should be considered if many items in the search corpus are near duplicates of each other.

The default value is 1.8.

joinmultiplier

A valid integer between 1.001 and 100

No

When specified, the multiplier will result in more items being retrieved for queries that contain both full-text and metadata components. This should only be increased if the set of full-text results have a small intersection with the set of metadata results for a significant number of queries.

The default value is 10.

sdidjoinmultiplier

A valid integer between 1.001 and 100

No

When specified, the multiplier will result in more items being retrieved for full-text queries. This should only be increased if there are many search results removed using the Search Results Removal feature.

The default value is 1.01.

Any query processor change will not take effect until an iisreset /force command is executed on each server used as front-end Web server.

Any modification of query processor settings will affect server performance.

The multipliers are used to calculate the number of results for a given query.

To determine the current setting of the query processor options, type the following syntax:

stsadm -o setqueryprocessoroptions –ssp <SharedServicesName>

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft