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.
SQL Profiler can support as many as 15 concurrently active traces. Open traces are displayed on the SQL Profiler tab.