Re: Post SP3 Full text performance degradation

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

anonymous_at_discussions.microsoft.com
Date: 10/06/04 

Date: Wed, 6 Oct 2004 06:22:58 -0700

Hilary,

I just saw the cpu flat-lining again, but the metric did
not really change.

Rob
>-----Original Message-----
>This is abnormal. There were some problems with the
search algorithim prior
>to SP 3 relating to ranking. If you are doing ordering
you may experieince
>some difference in performance.
>
>I noticed a performance increase. How many simultaneous
queries are you
>running? You can get this metric by looking at the
performance monitor
>counter Microsoft Search:Queries
>
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>
>
>"rob" <anonymous@discussions.microsoft.com> wrote in
message
>news:3ff201c4ab8e$5a1c3400$a301280a@phx.gbl...
>> Since upgrading to service pack 3a (from sql server with
>> no sp) I am experiencing performance issues with my full
>> text searches. Its hard to quantify the problem - but
>> since the upgrade I am definitely seeing significatnt
>> increase in duration for searches - especially when they
>> run concurrently.
>>
>> As part of the upgrade the catalogs were rebuilt.
>>
>> Any ideas would be appreciated
>
>
>.
>

Relevant Pages

  • Re: Cant reinstall IE6...
    ... IE and XP have a relationship unlike any previous version of Windows. ... By the way, if you have the opportunity to upgrade to XP, I would still ... Rob P ... >> am unwilling to chance overwriting all my data by doing an inplace ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Project 98 - Installing?
    ... No, it's not an upgrade, ont the advice of Rob I tried an XP ng an found the ... :>> "16 Bit Windows SubSytem ... :>> The system file is not suitable for running MS-Dos & Windows ...
    (microsoft.public.project)
  • Re: Latest iceweasel - package kept back
    ... Dunno about Rob, ... fails due to the fact xulrunner isn't going to be installed (from the ... upgrade to v8 which also indicates libmozjs8d will be ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: Sendmail upgrade advice
    ... "Rob" wrote: ... so it tells me the easiest way to build sendmail is to type sh Build ... > of upgrade on that file first? ... To unsubscribe, ...
    (freebsd-questions)
  • Post SP3 Full text performance degradation
    ... Since upgrading to service pack 3a (from sql server with ... no sp) I am experiencing performance issues with my full ... Its hard to quantify the problem - but ... As part of the upgrade the catalogs were rebuilt. ...
    (microsoft.public.sqlserver.fulltext)