Index Tuning Multiple Queries

4 Nov 2005 8:31 PM

Brett Ossman

I'm attempting to run the Index Tuning Wizard against multiple queries at
once (dozens) in SQL Query Analyzer. I put a GO at the end of them to
indicate a batch, select all the queries + GO, but the wizard only analyzes
the first query. I'm also avoiding the production hit of the Profiler,
unless a last resort.

Ideas?

Thanks

5 Nov 2005 10:22 AM

John Bell

Hi

Have you tried putting them into a .sql file and using that?

John

Show quote

"Brett Ossman" wrote:

> I'm attempting to run the Index Tuning Wizard against multiple queries at
> once (dozens) in SQL Query Analyzer. I put a GO at the end of them to
> indicate a batch, select all the queries + GO, but the wizard only analyzes
> the first query. I'm also avoiding the production hit of the Profiler,
> unless a last resort.
>
> Ideas?
>
> Thanks

7 Nov 2005 4:57 PM

Brett Ossman

Thanks for the tip, but unfortunately still only analyzed the first query.

Show quote

"John Bell" wrote:

> Hi
>
> Have you tried putting them into a .sql file and using that?
>
> John
>
> "Brett Ossman" wrote:
>
> > I'm attempting to run the Index Tuning Wizard against multiple queries at
> > once (dozens) in SQL Query Analyzer. I put a GO at the end of them to
> > indicate a batch, select all the queries + GO, but the wizard only analyzes
> > the first query. I'm also avoiding the production hit of the Profiler,
> > unless a last resort.
> >
> > Ideas?
> >
> > Thanks

12 Nov 2005 2:27 PM

John Bell

Hi Brett

Check out the topic on Index Tuning Wizard in books online and check if you
have any of the conditions it says that it will not work in. You could also
re-order the queries and see if it is the same query that gets tuned.

John

Show quote

"Brett Ossman" <BrettOss***@discussions.microsoft.com> wrote in message
news:7B9C9A35-F03B-4BEB-9288-EBF1AD47B21E@microsoft.com...
> Thanks for the tip, but unfortunately still only analyzed the first query.
>
> "John Bell" wrote:
>
>> Hi
>>
>> Have you tried putting them into a .sql file and using that?
>>
>> John
>>
>> "Brett Ossman" wrote:
>>
>> > I'm attempting to run the Index Tuning Wizard against multiple queries
>> > at
>> > once (dozens) in SQL Query Analyzer. I put a GO at the end of them to
>> > indicate a batch, select all the queries + GO, but the wizard only
>> > analyzes
>> > the first query. I'm also avoiding the production hit of the Profiler,
>> > unless a last resort.
>> >
>> > Ideas?
>> >
>> > Thanks