SQL Profiler v8
SQL Profiler captures statistical information and query execution plans for SQL statements executed during a trace session. You can use the information stored by SQL Profiler to identify performance issues. Before using SQL Profiler, you must install and configure SQL Profiler on each database you intend to profile.
sp_installing_sql_profiler sp_configuring_sql_profiler sp_create_new_trace sp_index_advisor sp_sql_profiler_tab
SQL Profiler can support as many as 15 concurrently active traces. Open traces are displayed on the SQL Profiler tab.