Posted by Zamdrist on 03/23/07 20:43

On Mar 23, 1:59 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
>
> If you have no access to these tables, you can't put indexes on it. So
> perhaps I misunderstand.

No I have access to all the objects via Enterprise Manager, I just
don't have access to the application code to see what it is doing,
there are however only a handful of queries/procedures, and over 70+
tables, so I fear the worst.
>
> In any case, you probably CAN get this information via profiler and looking
> at the queries as they come through the machine.
>
> Also, there's some tools (only source I know of is via the SQL Server
> Magazine website so they're copyrighted I believe) to follow wait
> statistics, which can be VERY powerful to find out where your application is
> doing a lot of querying.
>
> You can also try (though generally I don't find it useful) the Index Wizard
> in EM.

Thanks Greg.

[Back to original message]