"Sky Fly" <nobody@blackhole.com> wrote in message
news:c648kb$7sr0g$1@ID-18325.news.uni-berlin.de...
> Hello,
>
> I'm trying to use the Index Tuning Wizard to improve
> the performance of my stored procedure, but I'm having a
> problem. When setting up the ITW, I uncheck the option to
> keep all indexes to get the best possible recommendations.
> However, when I do this and run the wizard, I get the following
> error:
>
> "An error occurred trying to execute a SQL statement."
>
> When I check the option, then the ITW runs all right but
> it doesn't offer an recommendation.
>
> Can anyone help me figure out why I would be getting this
> error?
>
> --
> Akin
>
> aknak at aksoto dot idps dot co dot uk
>
>

"Vinodk" <vinodk_sct@NO_SPAM_hotmail.com> wrote in message
news:OM1MCv1JEHA.1944@TK2MSFTNGP10.phx.gbl...
> You need to have a good workload in hand to get proper recommendation from
> ITW. It is quite possible when you submit a simple workload that ITW may
not
> give you any recommendation. How big is the workload input provided.
>
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
>
> "Sky Fly" <nobody@blackhole.com> wrote in message
> news:c648kb$7sr0g$1@ID-18325.news.uni-berlin.de...
> > Hello,
> >
> > I'm trying to use the Index Tuning Wizard to improve
> > the performance of my stored procedure, but I'm having a
> > problem. When setting up the ITW, I uncheck the option to
> > keep all indexes to get the best possible recommendations.
> > However, when I do this and run the wizard, I get the following
> > error:
> >
> > "An error occurred trying to execute a SQL statement."
> >
> > When I check the option, then the ITW runs all right but
> > it doesn't offer an recommendation.
> >
> > Can anyone help me figure out why I would be getting this
> > error?
> >
> > --
> > Akin
> >
> > aknak at aksoto dot idps dot co dot uk
> >
> >
>
>

"Sky Fly" <nobody@blackhole.com> wrote in message
news:c65f86$7qsjo$1@ID-18325.news.uni-berlin.de...
> Hello Vinod,
>
> The workload is about 20 MB - but I don't think the problem is
> the size of the workload, because that wouldn't explain the
> ERROR that I am getting. In short, the ITW does not even complete
> its task of analysis before the error is thrown.
>
> Akin
>
> "Vinodk" <vinodk_sct@NO_SPAM_hotmail.com> wrote in message
> news:OM1MCv1JEHA.1944@TK2MSFTNGP10.phx.gbl...
> > You need to have a good workload in hand to get proper recommendation
from
> > ITW. It is quite possible when you submit a simple workload that ITW may
> not
> > give you any recommendation. How big is the workload input provided.
> >
> > --
> > HTH,
> > Vinod Kumar
> > MCSE, DBA, MCAD, MCSD
> > http://www.extremeexperts.com
> >
> > Books Online for SQL Server SP3 at
> > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> >
> >
> > "Sky Fly" <nobody@blackhole.com> wrote in message
> > news:c648kb$7sr0g$1@ID-18325.news.uni-berlin.de...
> > > Hello,
> > >
> > > I'm trying to use the Index Tuning Wizard to improve
> > > the performance of my stored procedure, but I'm having a
> > > problem. When setting up the ITW, I uncheck the option to
> > > keep all indexes to get the best possible recommendations.
> > > However, when I do this and run the wizard, I get the following
> > > error:
> > >
> > > "An error occurred trying to execute a SQL statement."
> > >
> > > When I check the option, then the ITW runs all right but
> > > it doesn't offer an recommendation.
> > >
> > > Can anyone help me figure out why I would be getting this
> > > error?
> > >
> > > --
> > > Akin
> > >
> > > aknak at aksoto dot idps dot co dot uk
> > >
> > >
> >
> >
>
>

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:OXiyn57JEHA.644@tk2msftngp13.phx.gbl...
> Have you tried running a profiler trace on the ITW ? This may show you
where
> and what statement is causing the issue.
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
>
> "Sky Fly" <nobody@blackhole.com> wrote in message
> news:c65f86$7qsjo$1@ID-18325.news.uni-berlin.de...
> > Hello Vinod,
> >
> > The workload is about 20 MB - but I don't think the problem is
> > the size of the workload, because that wouldn't explain the
> > ERROR that I am getting. In short, the ITW does not even complete
> > its task of analysis before the error is thrown.
> >
> > Akin
> >
> > "Vinodk" <vinodk_sct@NO_SPAM_hotmail.com> wrote in message
> > news:OM1MCv1JEHA.1944@TK2MSFTNGP10.phx.gbl...
> > > You need to have a good workload in hand to get proper recommendation
> from
> > > ITW. It is quite possible when you submit a simple workload that ITW
may
> > not
> > > give you any recommendation. How big is the workload input provided.
> > >
> > > --
> > > HTH,
> > > Vinod Kumar
> > > MCSE, DBA, MCAD, MCSD
> > > http://www.extremeexperts.com
> > >
> > > Books Online for SQL Server SP3 at
> > > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> > >
> > >
> > > "Sky Fly" <nobody@blackhole.com> wrote in message
> > > news:c648kb$7sr0g$1@ID-18325.news.uni-berlin.de...
> > > > Hello,
> > > >
> > > > I'm trying to use the Index Tuning Wizard to improve
> > > > the performance of my stored procedure, but I'm having a
> > > > problem. When setting up the ITW, I uncheck the option to
> > > > keep all indexes to get the best possible recommendations.
> > > > However, when I do this and run the wizard, I get the following
> > > > error:
> > > >
> > > > "An error occurred trying to execute a SQL statement."
> > > >
> > > > When I check the option, then the ITW runs all right but
> > > > it doesn't offer an recommendation.
> > > >
> > > > Can anyone help me figure out why I would be getting this
> > > > error?
> > > >
> > > > --
> > > > Akin
> > > >
> > > > aknak at aksoto dot idps dot co dot uk
> > > >
> > > >
> > >
> > >
> >
> >
>
>