Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Setqueryprocessoroptions: Stsadm operation (Office SharePoint Server)

SharePoint 2007

Updated: April 28, 2009

Applies To: Office SharePoint Server 2007

Updated: 2009-04-28

Operation name: Setqueryprocessoroptions

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

Syntax

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

Parameters

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.

Remarks

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.

Examples

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

stsadm -o setqueryprocessoroptions –ssp <SharedServicesName>

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.