Re: Full Text Max Size?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 01/14/05 

Date: Thu, 13 Jan 2005 18:56:49 -0800

Charlie,
Yes, I do. First of all, what is the exact version of SQL Server (7.0 or
2000) and on what OS platform is it deployed? Could you post the full output
of -- SELECT @@version -- as this is VERY helpful information in
troubleshooting such SQL FTS performance issues!

Secondly, and depending upon what your is your SQL Server version and SP
level as well as the exact query that your are getting these errors, you may
want to checkout KB article 818883 "PRB: You may receive error 7619 when you
run a full-text query that contains many OR operators in the search string"
at http://support.microsoft.com/default.aspx?scid=kb;en-us;818883 as one of
the symptoms is error: "Not enough storage is available to complete this
operation" as this occurs on SQL Server 2000 SP3 and when your CONTAINS
query contains many logical OR operators.

However, because of the larger number of rows (30 million), in your
FT-enable table, you may have encountered additional problems related to the
Master Merge. Specifically, you should review your server's Application
Event log for "Microsoft Search" or MssCi source events - errors, warnings
AND informational for any related Master Merge paused conditions.
Furthermore, you should review the Performance Monitor (Perfmon) counters
for Microsoft Gatherer: Reason to back off, Microsoft Gatherer Projects:
Gatherer Paused Flag, and Microsoft Search Indexer Catalogs: Merge Progress
to determine if there is an existing issue with the Master Merge process.

Depending upon your reply, I can provide you with more specific
recommendations.
Thanks,
John 

-- 
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Charlie Pyne" <cpyne@partners.org> wrote in message
news:#SjvpQb#EHA.3988@TK2MSFTNGP11.phx.gbl...
>
> Hi,
>
> Does anyone have experience with Full Text catalogs on large tables? We
> have a full text catalog on a table with about 30 million rows. Acording
> to BOL, once you get over 1 million you'll need to make some
> adjustements. Our system works, but often we get the following errors
> with ad hoc queries. The server has 8GB of RAM and 4 3GHz processors.
> Does anyone have experience working with a table this big? Any
> suggetions as to what could cause these errors? The only thing I could
> find was BUG#: 469483 on MS's site, but we're not using any OR clauses
>
> Thanks
>
> Here's the errors....
>
> (query)
> SELECT * FROM acc_results ar
> WHERE CONTAINS(finding_text, 'cell')
>
> #1
> Server: Msg 7619, Level 16, State 1, Line 1
> Execution of a full-text operation failed. Not enough storage is
> available to process this command.
>
>
> #2
> Server: Msg 7342, Level 16, State 1, Line 1
> Unexpected NULL value returned for column '[FULLTEXT:acc_results].KEY'
> from the OLE DB provider 'Full-text Search Engine'. This column cannot
> be NULL.
> OLE DB error trace [Non-interface error: Unexpected NULL value returned
> for the column: ProviderName='Full-text Search Engine',
> TableName='[FULLTEXT:acc_results]', ColumnName='KEY'].
>
>
> #3
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'Full-text Search Engine' reported an error.
> [OLE/DB provider returned message: Not enough storage is available to
> process this command.]
> OLE DB error trace [OLE/DB Provider 'Full-text Search Engine'
> IRowset::GetNextRows returned 0x80004005: ].
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • =?us-ascii?Q?Re:=20SharePoint=20Services=20=16=20SQL=202005?=
    ... It is strange that it does not work for you in SQL Server 2005. ... Try more general keywords. ... The search engine automatically includes variations of words based upon the ... > The reason is that WSS search uses SQL Full Text Search. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to Generate Snippets of the doc by Full-text Search Engine
    ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ... send the entire results back to the client and have the hit marked up ... Actually speaking, my system is just like a enterprise search engine, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Nested Nodes in XML from a table
    ... > Well considering that many persons would be accessing a search engine; ... > who knows how many of them will be in the future acessing at the same ... > is much faster than accessing the actual sql server. ... I don't have Books Online 2005 on this machine, ...
    (comp.databases.ms-sqlserver)
  • SQL Server linked server to Active Directory
    ... When I try to connect a SQL Server to our Active Directory via SQL Server's 'Linked Servers', ... Could not obtain a required interface from the OLE DB provider 'ADsDSOObject'. ... OLE DB error trace [OLE/DB Provider 'ADsDSOObject' IUnknown:: QueryInterface returned ... ...
    (microsoft.public.win2000.security)
  • doing a search
    ... and using SQL Server 2000. ... I need to add a search engine. ... the criteria typed into the box, and rank them and highlight key words. ... sample code would be best. ...
    (microsoft.public.inetserver.asp.general)