Index Tuning Wizard

[Chloe Crowder]

Hi

I tried running ITW against one of our databases, and it came up with a
number of suggestions, but also filled the Application Log with messages
like:-

The description for Event ID ( 4 ) in Source ( ITW ) could not be found. It
contains the following insertion string(s):
Error in Parsing Event:
declare @P1 nvarchar(1)
declare @P2 nvarchar(1)
declare @P3 nvarchar(1)
declare @P4 nvarchar(1)
EXEC "dbo"."sp_get_R AO_indexW2K2" @P1 , @P2 , @P3 , @P4 .

Does anyone know if this is serious (or indeed what it means at all)?

There were no apparent errors in the ITW run.

Chloe Crowder

[John Bell]

Re: Index Tuning Wizard

Hi

This is not a stored procedure I recognise or can find. Are you running ITW
from a script or profile? If yes then does it exist there?

Also, if you are using procedure names "sp_" SQLServer will be expecting
them to be in the master database, and will check it first, before the
current database for your stored procedure. By calling your procedure
something other than "sp_" you should improve performance.

John



"Chloe Crowder" <chloe.crowder@ bl.uk> wrote in message
news:bfrc2o$abe $1@south.jnrs.j a.net...[color=blue]
> Hi
>
> I tried running ITW against one of our databases, and it came up with a
> number of suggestions, but also filled the Application Log with messages
> like:-
>
> The description for Event ID ( 4 ) in Source ( ITW ) could not be found.[/color]
It[color=blue]
> contains the following insertion string(s):
> Error in Parsing Event:
> declare @P1 nvarchar(1)
> declare @P2 nvarchar(1)
> declare @P3 nvarchar(1)
> declare @P4 nvarchar(1)
> EXEC "dbo"."sp_get_R AO_indexW2K2" @P1 , @P2 , @P3 , @P4 .
>
> Does anyone know if this is serious (or indeed what it means at all)?
>
> There were no apparent errors in the ITW run.
>
> Chloe Crowder
>
>[/color]