Multiple identical events in Application Event Log

Posted on 2009-02-18
Medium Priority
Last Modified: 2013-11-05
We have a Windows 2003 Server (SP2), dedicated to our databases. We use SQL Server 2000 for our databases and have full-text search for all the databases, running at different times daily. The full-text search for most of the databases are incremental indexing at night. For sometime now we see in the Application Event Viewer of the server that for each db that search indexing starts, it happens 4 times rather than just once, even though all four have same Event IDs and started at exact same time. Therefore, in the Event Viewer, there are 4 copies of Gatherer log for the search index for a database, instead of one. We wonder if that has performance/load issues on our server since there are many databases? Why/how would a full-text index schedule for a database produce 4 events instead of 1?
Question by:atomic500
1 Comment
LVL 22

Accepted Solution

Paka earned 2000 total points
ID: 23681351
You might have 4 events because you have 4 indexing jobs starting at the same time.  How many databases do you have on the server?  With SQL, you can create indexes on individual tables and have separate schedules for the jobs.  In your case, you might have 4 tables being incrementally indexed with the same start time.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Loops Section Overview

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question