Index tuning wizard

[vganeshbabu]

Hi,
How do i install the index tuning wizard?? I have installed the sql 2000 enterprise edition both client & Db. But now ablt to find the Index tuning wizard..

Please Help

Thanks & Regards,

V.Ganesh Babu

 

[hmckillop]

Go into Enterprise manage, select tools, wizards and then index tuning wizard.
This should do it.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[hmckillop]

Sorry forgot a step,
tools, wizards, expand management and then index tuning wizard

"I'm living so far beyond my income that we may almost be said to be living apart

 

[vganeshbabu]

Hi hmckillop,
I went there but it is not listed there.. it only shows "Register Server Wizard"..

Ganesh

 

[gmmastros]

Usually, the Index Tuning Wizard is used to increase the performance of a slow running query. I don't use the Index Tuning Wizard very often, but when I do, these are steps the I follow.

1. Open the Query Analyzer.
2. Load your query.
3. On the menu, click Query -> Index Tuning Wizard



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[vganeshbabu]

I checked it.. but it is disabled..

Ganesh

 

[gmmastros]

Hmmm....

If I open the Query Analyzer and immediately go to Query -> Index Tuning Wizard, it's greyed out for me too.

However, if I write a query in the window, then it becomes enabled.

See step #2 of my previous post (Load your query).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[vganeshbabu]

Hi George,
Still I am seeing the index tuning wizard - disabled after writing the query or load the query thru a sql file also..

Looks like INdex tuning wizard is not install, is there a way to install it separate ?

Ganesh

 

[vganeshbabu]

I found it.. it needs administrator privilleges.. my login did not had it.. now it is fixed..

Thanks guys..

Ganesh