I have been using the index tuning wizard to review some of my stored procs,
and views. So far most of my indexes have been set up well, but I am curious
as to how they would look under a production system load. I was thinking of
running a profile for about 30 minutes or so on the prod system, and then
using that profile for the index tuning wizard to see what it says.

Would this be of value?
Can running a profile on a prod system be dangerous?


--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com

Hi,

No problem, you run the profiler on the production server. But please run
the profiler from your client machine pointing towards the server.

FYI, I used to do this way on my server with more than 500 users connected
and never faced any performance bottle neck.

Thanks
Hari
MCDBA


"BenignVanilla" <bv@tibetanbeefgarden.com> wrote in message
news:QqadnY7BmIN131KiRVn-jg@giganews.com...
> I have been using the index tuning wizard to review some of my stored
procs,
> and views. So far most of my indexes have been set up well, but I am
curious
> as to how they would look under a production system load. I was thinking
of
> running a profile for about 30 minutes or so on the prod system, and then
> using that profile for the index tuning wizard to see what it says.
>
> Would this be of value?
> Can running a profile on a prod system be dangerous?
>
>
> --
> BV.
> WebPorgmaster - www.IHeartMyPond.com
> Work at Home, Save the Environment - www.amothersdream.com
>
>

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:OzE1jinuDHA.1760@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> No problem, you run the profiler on the production server. But please run
> the profiler from your client machine pointing towards the server.
>
> FYI, I used to do this way on my server with more than 500 users connected
> and never faced any performance bottle neck.
>
> Thanks
> Hari
> MCDBA
<snip>

Thanks. I appreciate the response.

Did you find the profiles to useful? Did you use them with the index tuning
wizard? Did you find that the wizard helped performance using the profile,
over just raw analysis of queries or views in a non-prod system?


--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com