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:
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.