Index server Performance issues

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Gaunt (sgaunt_at_emeraldinsight.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 17:40:03 -0000

Hi,

We're using Index Server as a linked server from SQL server. One of the
tasks we ask index server to perform is a count on the number of particular
file types in the catalog. The SQL query we issue for this is:

SELECT FILENAME, RANK FROM
OPENQUERY( Published, 'SELECT TOP 1000 FILENAME, RANK FROM
UATCLDB01.Published..SCOPE(''"G:\Insight_Share\ContentLoad\Output\Published\
EmeraldAbstractOnlyArticle",
"G:\Insight_Share\ContentLoad\Output\Published\EmeraldFullTextArticle"'')
WHERE CONTAINS(''"management"'') AND FILENAME NOT LIKE ''%_ref.html'' '
ORDER BY RANK DESC)

The query takes about 3 seconds. When concurrent requests are made, the CPU
hits 100% after 4 users. The scalability of the query dramatically
decreases to 15 seconds for 10 concurrent queries.

We have made the adjustments to the registry as recommended:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex\IsEnumAllow
ed to 0 (zero)

Pagefile.sys :
Min 4096 Max 4096 (physical memory is 4096Mb)

MaxActiveQueryThreads was 9 now 64

The IsapiRequestThresholdFactor does not exist on the server but looks like
it has a part to play ?

Grabbed this off of MSDN:

 MaxActiveQueryThreads
The MaxActiveQueryThreads entry is the maximum number of active threads to
process queries made using ISAPI.

Summary
Type: REG_DWORD
Units: Threads
Default: 2
Range: 1 - 1000

Remarks
The product of the value of the MaxActiveQueryThreads entry and the value of
the IsapiRequestThresholdFactor entry establishes the maximum number of
concurrently processed asynchronous queries made using ISAPI.

These changes did not seem to have any effect on performance. Are there any
guidlines as to improve the scalabilty and run the queries concurrently??

Cheers

Steve

Relevant Pages

  • RE: How to discard the error in SQL query
    ... PrintError will just print the error and go on its merry way ... How to discard the error in SQL query ... I am executing list of SQL queries from a file. ...
    (perl.dbi.users)
  • SQL parsing library
    ... take an SQL query (which may already contain some ... metrics on the frequency and average running time of queries in the ... and I want to treat all queries of the same general form as ...
    (comp.lang.java.databases)
  • C# Excel multiple cell/column/row SQL Query Question
    ... I am trying to select a range of data within an excel spreadsheet using ... a SQL query. ... The two queries below do the trick but I was wondering if ... there's any way to combine both of these SQL queries into one query? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL parsing library
    ... > in mind is as follows: take an SQL query (which may already contain some ... > metrics on the frequency and average running time of queries in the ... and I want to treat all queries of the same general form as ...
    (comp.lang.java.databases)
  • Re: Open Office
    ... Colin Matthews wrote: ... OpenOffice uses quite a few file types for its different components, ... queries. ...
    (comp.sys.acorn.apps)