Why freetext query become very slow all of a sudden
- From: DL <tatata9999@xxxxxxxxx>
- Date: Sat, 26 Apr 2008 16:11:25 -0700 (PDT)
Env: MS SQL Server 2005 developer edition on Windows XP Pro
I have a fairly complex query that create a 'variable TABLE' and then,
run a set of freetext search using the CONTAINS predicate,
and add matches to this table;
and then fetch the matches from the target table.
The execution used to be 1/3 or 1/4 or even less of a second. But
now, all of a sudden, it almost takes 1 second to run it. Nothing
really has changed, be it, the db server, the db or the box itself.
How come? I'm puzzled.
Digging the log files, I found the following entry,
"04/17/2008 03:49:26,spid1s,Unknown,A significant part of sql server
process memory has been paged out. This may result in a performance
degradation. Duration: 374427 seconds. Working set (KB): 8028<c/>
committed (KB): 24288<c/> memory utilization: 33%.
", wtf? I mean, how come?
I ran some similar queries using a query client, speed seems very
good...
Also, could it be caused by some Windows XP automatic update?
(unintended consequence)
Also, I'm using a third party tool for the web presentation, could
some of its service degrade because previously it was good?
Thanks.
.
- Prev by Date: Re: Select CASE returning NULL value
- Next by Date: Select date in british format
- Previous by thread: Select CASE returning NULL value
- Next by thread: Select date in british format
- Index(es):
Relevant Pages
|
