Full text search

Hi everyone

I am using SQL server 2000 with SP3 on Windows 2003 server.

I have scheduled a job to populate a full text index incrementally. Everytime it runs the job to populate the index table it writes some messages into event log.
Like this:
1.
Event Type : Information
Event Source : Microsoft Search
Event Category: Gatherer
Event ID : 3019
Date :8/7/2004
Time :2:21:00 PM
User : N/A
Computer : ARC-03-DEV
Description:1
The crawl on project <SQL Server SQL00002000009> has started.

2.
Event Type : Information
Event Source : Microsoft Search
Event Category: Gatherer
Event ID : 3047
Date :8/7/2004
Time :2:21:00 PM
User : N/A
Computer : ARC-03-DEV
Description:
The end of the incremental crawl for project <SQL Server SQL00002000009> has been detected. The Gatherer successfully processed 998 documents totaling 0K. It failed to filter 0 documents. 998 documents were modified. 0 URLs could not be reached or were denied access.

The event log is getting filled frequently.

Is there any way to stop this messages?
It is normal for Microsoft Search to write this message into EventLog?
Even though there is no chanage in the database it give the above messages.

Any one know the reason please help.

Quick reply is appreaciated.

Reagrda,

Atiq RahmanYes, there is a way to suppress the message, but it is a bad idea so I don't remember the details.

Yes, it is perfectly normal for the indexing service to issue those messages, even if it doesn't make any changes.

-PatP|||Hi Pat,

Thanks for the information.

I want to stop this entries getting into Eventlog. Even if it is bad, if you remember please let me know. I want to try it.

Regards,

Atiq Rahman

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
LoginName: NT AUTHORITY\SYSTEM
this many connections is unacceptable. is this normal behavior for sql server?
Why do you think it is unacceptable?
SQL FTS spawns many threads to grab as much data as possible simultaneously
to make indexing happen as fast as possible.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Karel" <Karel@.discussions.microsoft.com> wrote in message
news:54AB17DB-A491-48CD-B513-8195EE761F34@.microsoft.com...
>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
> LoginName: NT AUTHORITY\SYSTEM
>
> this many connections is unacceptable. is this normal behavior for sql
> server?
|||One of my web applications threw the exception:
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and max pool size was reached.
After an investigation I found no errors in the web application that could
cause it use more than one sql connection, and i discovered that the indexing
process, which swallowed up many connections, took place at the very instant
of the error. I am suspecting that the max connections was reached as a
result of the full text indexing process.
"Hilary Cotter" wrote:

> Why do you think it is unacceptable?
> SQL FTS spawns many threads to grab as much data as possible simultaneously
> to make indexing happen as fast as possible.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Karel" <Karel@.discussions.microsoft.com> wrote in message
> news:54AB17DB-A491-48CD-B513-8195EE761F34@.microsoft.com...
>
>
|||PKM uses a different connection pool. It won't exhaust your web application
connection pool.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Karel" <Karel@.discussions.microsoft.com> wrote in message
news:75BCD0DE-308F-4F2C-9BFA-0A19F74200C5@.microsoft.com...[vbcol=seagreen]
> One of my web applications threw the exception:
> Timeout expired. The timeout period elapsed prior to obtaining a
> connection
> from the pool. This may have occurred because all pooled connections were
> in
> use and max pool size was reached.
> After an investigation I found no errors in the web application that could
> cause it use more than one sql connection, and i discovered that the
> indexing
> process, which swallowed up many connections, took place at the very
> instant
> of the error. I am suspecting that the max connections was reached as a
> result of the full text indexing process.
> "Hilary Cotter" wrote:
|||Yeah, i understand what you just said. I'm not accusing the fulltext process
of tapping into the web app's connection. As far as i know, thats just not
possible. The problem im having is that the full text indexing process eats
up all available connections, not allowing anything else to connect.
Here is the scenario:
1. begin fulltext process: exec sp_fulltext_catalog N'Category', N'start_full'
2. in query analyzer execute: sp_who2 (view the fulltext process using 50+
connections)
3. start the webapp: hit the website and trigger a sql connection.
result: The web app can't connect. why? because the fulltext process used up
all of the connections! The web application then times out and throws the
exception.
"Hilary Cotter" wrote:

> PKM uses a different connection pool. It won't exhaust your web application
> connection pool.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Karel" <Karel@.discussions.microsoft.com> wrote in message
> news:75BCD0DE-308F-4F2C-9BFA-0A19F74200C5@.microsoft.com...
>
>

Full Text - Trusted account

Hello,
When I run an incremental/full job for a full text
catalog on win 2k , SQL 2K sp3a cluster server, i am
getting this in the SQL error log
Login failed for user domain\servername$
We recently removed the local admin group having syadmin
access to the server.
I changed the Job owner to the SQL Startup account, even
then it is using the above login. Why is that ?
I couldnt be able to grant the login access as i am not
able to see in the list of users...
Where is this login, can i change something to fix ?
Thanks
- Saravana
can you add this account to the system administrator role?
if not exists (select * from master.dbo.syslogins where loginname = N'NT
Authority\System')
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System', N'us_english'
GO
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
GO
"SK" <anonymous@.discussions.microsoft.com> wrote in message
news:1420b01c41808$d9e0f460$a601280a@.phx.gbl...
> Hello,
> When I run an incremental/full job for a full text
> catalog on win 2k , SQL 2K sp3a cluster server, i am
> getting this in the SQL error log
> Login failed for user domain\servername$
> We recently removed the local admin group having syadmin
> access to the server.
> I changed the Job owner to the SQL Startup account, even
> then it is using the above login. Why is that ?
> I couldnt be able to grant the login access as i am not
> able to see in the list of users...
> Where is this login, can i change something to fix ?
> Thanks
> - Saravana
>

Full Backup

I start a full backup on a database at 5pm. The backup job takes 3
hours to complete. While the backup job is running, someone inserts
records to the db. Will the backup include the new records? Or in
other words, are the contents of a SQL Server backup a snapshot of the
database at the start time of the backup?I had read somewhere (can not remember where) that MS SQL 6.5 was a snapshot
of the database at the start time of the backup, while SQL 7 and 2000 are a
snapshot of the database at the end time of the database. In each case, the
backup process is watching what is going on in the log file.

Oscar...

"DBA" <kaylisse@.yahoo.com> wrote in message
news:ffe01bb8.0411081044.4446a7ab@.posting.google.c om...
> I start a full backup on a database at 5pm. The backup job takes 3
> hours to complete. While the backup job is running, someone inserts
> records to the db. Will the backup include the new records? Or in
> other words, are the contents of a SQL Server backup a snapshot of the
> database at the start time of the backup?