SQL Server Profiler Tool

ms SQL Server Profiler Overview:
ms SQL Server Profiler is a GUI interface for SQL trace, provides event monitoring for SQL Server database engine or analysis service instances. Developers can capture event-related data to physical files or DB tables to facilitate future analysis performance.
SQL trace is a series of system stored procedures for SQL Server database engine trace. For more information, see: http://msdn.microsoft.com/en-us/library/ms191006 (SQL .90). aspx

SQL Server Profiler idioms:
Event: actions generated by SQL Server engine, such as DB connections and DML execution.
Event class: a specific type of event, such as DB connection successful.
Data column: attribute in event class.
Trace: capture information based on event class, data column, and filter.
Filter: Data column-based capture conditions.
Template: The specific configuration of Trace, which can be reused.

SQL Service profiler function:
Creates a trace based on reusable templates;
Observe the trace result set during the trace operation;
Store the trace result set in a physical file or DB table;
Start, stop, pause, and modify the trace result set;
Reproduce the trace result set

template:
you can create and save a custom template on the UI, the tool also provides several templates to meet common trace requirements.
sp_counts: capture the execution behavior of the stored procedure.
standard: capture the currently executed stored procedures and SQL statements.
tsql: capture the SQL statements submitted to the engine by the client.
tsql_duration: capture the execution time of SQL statements submitted to the engine by the client.
tsql_grouped: capture the SQL Execution statistics of specific clients.
tsql_replay: capture SQL Execution that can be reproduced.
tsql_sps: capture the details of all stored procedures in progress.
tuning: capture the specific status of all the stored procedures or SQL statements being executed.

associate trace with Windows performance log data:
open a trace file or data table containing starttime and endtime, in the "file" menu of "SQL Server Profiler", select "import performance data" and select the system monitor object to be associated with trace .