Re: How to find indexes in use w/ Profiler?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Chris

This is a hard issue to deal with in SQL 2000. Unfortunately, the only way
I'm aware of to work out which indexes are being used is to capture
execution plans via SQL Profiler traces & run scripts over them (using ::
fn_trace_gettable()) to work out which indexes are being used. SQL 2005, on
the other hand, has a nice management view you can simply query..

Regards,
Greg Linwood
SQL Server MVP

"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F828D765-278A-4C92-BE61-61E60430C5B5@xxxxxxxxxxxxxxxx
sorry... sql2000

"Greg Linwood" wrote:

Hi Chris

Are you using SQL 2000 or SQL 2005?

Regards,
Greg Linwood
SQL Server MVP

"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E5BC071-835E-49DA-A98A-053604D0243A@xxxxxxxxxxxxxxxx

How do I determine what indexes are being used using profiler?

What events do I capture? I see IndexID as a data column.. I assume I
need
this to query sysindexes...

tia,
chris






.

Relevant Pages

  • Re: Select returns unwanted data
    ... As the query stands, ... Tibor Karaszi, SQL Server MVP ... > "Mike Epprecht " wrote: ...
    (microsoft.public.sqlserver.programming)
  • Re: Too many results error
    ... SQL Server MVP ... "Simon Sabin" wrote: ... The query I used was as follows (generic field / table placeholder ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Statement or Cursor
    ... Regards, ... SQL Server MVP ... >> Greg Linwood ...
    (microsoft.public.sqlserver.programming)
  • Re: Too many results error
    ... SQL 2005 has a very different architecture to SQL 2000 so more rows can be managed ... SQL Server MVP ... The query I used was as follows (generic field / table placeholder ... This seems to be contrary to the fix, which is supposed to throw the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: CPU utilization not even
    ... Looks like your query is only using 1 processor. ... Server is configured to use all processors. ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)