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