Monitor Index Usage.

microsoft.public.sqlserver.tools

1 Mar 2006 6:35 PM

mpighin

Hi,

Is there any tool out there that can monitor what indexes are being used in
SQL Server? Example a filter in SQL Server Profiler for index usage?

Marcel

2 Mar 2006 10:46 AM

Robert Klemme

mpighin wrote:

> Hi,
>
> Is there any tool out there that can monitor what indexes are being
> used in SQL Server? Example a filter in SQL Server Profiler for index
> usage?

I don't know a direct way at the moment, but you can get Profiler to write
text execution plans and search them for your index's name. HTH

Kind regards

robert