How to index tune 15 minutes of live activity?

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
some other logging tool, grab 15 minutes of data being executed on the live
SQL Server, and then do an index tuning analysis on that. Can someone
please tell me how?There is a tutorial on Database Engine Tuning Advisor on BOL. Go to SQL
Server 2005 Tutorials, SQL Server Tools Tutorials, Database Engine Tuning
Advisor Tutorial.
Ben Nevarez, MCDBA, OCP
Database Administrator
"D. Patrick" wrote:
> With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
> some other logging tool, grab 15 minutes of data being executed on the live
> SQL Server, and then do an index tuning analysis on that. Can someone
> please tell me how?
>
>sql