 |
|
|
|
Next: update multiple rows continue past exceptions
|
| Author |
Message |
External
Since: Dec 14, 2009
Posts: 1
|
(Msg. 1) Posted: Mon Dec 14, 2009 8:16 am
Post subject: opening, populating, anything with FTS is extremely slow
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
|
|
|
select FulltextCatalogProperty(N'houston', N'PopulateStatus')
Error: 942, Severity: 14, State: 4
The duration on this query is 12,530 ms. We have 440 databases all each
have a tiny (1mb ) FT index. Doing anything with FT is extremely slow. We
have the same setup on two other servers and it runs fine.
Anyone have any ideas?
select FulltextCatalogProperty(N'houston', N'UniqueKeyCount')
Error: 2812, Severity: 16, State: 62
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) |
|
| Back to top |
|
 | |
External
Since: Dec 14, 2009
Posts: 1
|
(Msg. 2) Posted: Mon Dec 14, 2009 2:54 pm
Post subject: Re: opening, populating, anything with FTS is extremely slow [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
that's a lot of databases. Are you using the -g option?
"david pride" wrote in message
> select FulltextCatalogProperty(N'houston', N'PopulateStatus')
> Error: 942, Severity: 14, State: 4
>
> The duration on this query is 12,530 ms. We have 440 databases all each
> have a tiny (1mb ) FT index. Doing anything with FT is extremely slow.
> We
> have the same setup on two other servers and it runs fine.
>
> Anyone have any ideas?
>
> select FulltextCatalogProperty(N'houston', N'UniqueKeyCount')
> Error: 2812, Severity: 16, State: 62
>
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) |
|
| Back to top |
|
| |
External
Since: Dec 14, 2009
Posts: 1
|
(Msg. 3) Posted: Mon Dec 14, 2009 4:26 pm
Post subject: Re: opening, populating, anything with FTS is extremely slow [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I don't use the -g option.. we have the same setup on two other servers and
they run more db's and they are running without a problem. Is there a way
to reinstall the FTS service without dropping the existing indexes? it is
about the only thing we can think off. Everything else appears to be the
same and there isn't anything in the logs explaining why it would be slow.
Use the default for the -g parameter unless you see the following warning in
the SQL Server error log:
WARNING: Clearing procedure cache to free contiguous memory
I don't see the above in our logs, so I don't think i need to increase the
default memory req.
"hilary" wrote:
> that's a lot of databases. Are you using the -g option?
> >> Stay informed about: opening, populating, anything with FTS is extremely slow |
|
| Back to top |
|
| |
External
Since: Aug 28, 2004
Posts: 1259
|
(Msg. 4) Posted: Wed Dec 16, 2009 8:55 am
Post subject: Re: opening, populating, anything with FTS is extremely slow [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
There is no way to reinstall SQL FTS without breaking the full text indexes.
The -g option has advantages when you have large numbers of databases.
There must be something different in the configurations of the three servers
which account for the slowness on this server. Perhaps run the best practice
analyzer to see if it picks up anything.
"david pride" wrote in message
>I don't use the -g option.. we have the same setup on two other servers and
> they run more db's and they are running without a problem. Is there a
> way
> to reinstall the FTS service without dropping the existing indexes? it is
> about the only thing we can think off. Everything else appears to be the
> same and there isn't anything in the logs explaining why it would be slow.
>
> Use the default for the -g parameter unless you see the following warning
> in
> the SQL Server error log:
> WARNING: Clearing procedure cache to free contiguous memory
>
>
> I don't see the above in our logs, so I don't think i need to increase the
> default memory req.
>
>
> "hilary" wrote:
>
>> that's a lot of databases. Are you using the -g option?
>> >> Stay informed about: opening, populating, anything with FTS is extremely slow |
|
| Back to top |
|
| |
| Related Topics: | full text indexing opening many connections - i created a job that performs indexing. the execution time takes only a second. i noticed, however, using SQL Profiler that the process opened 32 connections! trace details.... EventClass: Audit Login ApplicationName: PKM NTUserName: System..
First FTS-query to slow - We are using FTS on a table which has for the moment 4500 rows. When we restart the FTS-service, or no one uses the search for a while, then the first FTS-query takes up to 60 seconds. (also when there is only 1 record returned) While lookalike queries...
Text tying too slow? - While I am typing, for somr reason, I have to really type slow???? or it will not type correct. Can anyone help me change my typing speed? [like changing the speed of your coursor]..please help, if u know where I need to go to do this, let me know.....
Fulltext search too slow - Hi, I am using an FT index on a column (varchar(4000) with an average length of 100) in a table that contains about 1 million rows. My tiny performance test looks like declare @t datetime set @t = getdate() select count(*) from..
fts- contains expression: slow the first time fast the oth.. - I have a table with 1,500,000 name and first name I use Full text search on name and first name when I use a contains expression like select ... from table1 where contains( name,'abc') the query take 45 secs immediatly after this test I search for.... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
