|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to find indexes in use w/ Profiler?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 Hi Chris
Are you using SQL 2000 or SQL 2005? Regards, Greg Linwood SQL Server MVP Show quote "Chris" <Ch***@discussions.microsoft.com> wrote in message news:6E5BC071-835E-49DA-A98A-053604D0243A@microsoft.com... > > 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 > sorry... sql2000
Show quote "Greg Linwood" wrote: > Hi Chris > > Are you using SQL 2000 or SQL 2005? > > Regards, > Greg Linwood > SQL Server MVP > > "Chris" <Ch***@discussions.microsoft.com> wrote in message > news:6E5BC071-835E-49DA-A98A-053604D0243A@microsoft.com... > > > > 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 > > > > > 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 Show quote "Chris" <Ch***@discussions.microsoft.com> wrote in message news:F828D765-278A-4C92-BE61-61E60430C5B5@microsoft.com... > sorry... sql2000 > > "Greg Linwood" wrote: > >> Hi Chris >> >> Are you using SQL 2000 or SQL 2005? >> >> Regards, >> Greg Linwood >> SQL Server MVP >> >> "Chris" <Ch***@discussions.microsoft.com> wrote in message >> news:6E5BC071-835E-49DA-A98A-053604D0243A@microsoft.com... >> > >> > 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 >> > >> >> >>  
Other interesting topics
|
|||||||||||||||||||||||
