question

onedozenbagels avatar image
onedozenbagels asked

Index Tuning Wizard Fills Application Log With Error Messages

I am trying to Tune the indices on a SQL Server 2000 database. Here are my steps:

  1. Started tracing in SQL Profiler (I am using the default settings).
  2. Used the application for a while to generate data.
  3. Stopped the trace.
  4. Ran the Index Tuning Wizard and told it analyze the trace that I created.
  5. During the analysis a system message popped up saying that the Application Log was full.
  6. ITW finished its analysis, and reported that no indices need to be changed.
  7. The application log is full of query parsing errors that look like this:
Event Type: Error
Event Source:   ITW
Event Category: None
Event ID:   4
Date:   	10/29/2009
Time:   	10:13:25 AM
User:   	N/A
Computer:   VM-WIN2KS-SQL-R
Description:
The description for Event ID ( 4 ) in Source ( ITW ) cannot be found.
The local computer may not have the necessary registry information or message
DLL files to display messages from a remote computer. The following
information is part of the event: 
 Error in Parsing Event:
exec sp_executesql N'SELECT Users.* FROM Users 
WHERE Users.FirstName=@720 ORDER BY DateEntered ASC.

What is going on?

sql-serversql-server-2000indexing
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

We ended up switching to SQL Server 2005 and the problem has gone away.
0 Likes 0 ·

1 Answer

·
Gustavo avatar image
Gustavo answered

I did a google search for "The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer"

And found several windows/network/COM+ related errors, like for example: http://forums.techarena.in/windows-server-help/614688.htm http://forums.iis.net/t/1145358.aspx http://www.tomshardware.com/forum/197452-46-resolution-error-code-event-viewer http://community.landesk.com/support/docs/DOC-3007;jsessionid=902BD5075BE620F002AE13D2611AB85E http://www.derkeiler.com/Newsgroups/microsoft.public.security.virus/2008-06/msg00054.html

So, the errors you are receiving, could not be originated by ITW, but by other sources, and whatever solution you found for this windows/network/COM+ problem could also solve your problem.

Let us know if this helps.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.