Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-steve
steve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net. ..
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>
|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
?.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a crit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net. ..
> be
> for
> (Profiler,
>