Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005

    Unanswered: Index tuning wizard error


    When I try to run the ITW to increase performance I get this error in the event viewer. Earlier I have used the ITW with success but now I dont get any more index recommendations, just this error. Do you know what it means :

    "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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:
    Error in Parsing Event:
    execute sp_Sys'.

  2. #2
    Join Date
    Nov 2002
    Sorry, never used it, but it sounds you need to reinstall

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2005
    Do you mean reinstall the whole MSSQL installation or just ITW??

  4. #4
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I've seen this message occaisionally when someone runs ITW (the Index Tuning Wizard) on machines that don't have SQL installed. Our DBAs always install SQL Server Developer Edition on their workstations, and they are the only ones that use ITW, so its been ages since I've seen that error.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts