dbForge Event Profiler for SQL Server is a free tool that helps you capture SQL Server events in physical trace files. These files can be analyzed in order to identify and troubleshoot SQL Server performance issues, whether they are caused by high server load or by certain queries that impact database stability.
Capture server events: You can create traces to collect information about events occurring on the server. This will help you monitor the performance and analyze the resource utilization of your server, as well as locate and eliminate potential issues.
Set event sources: To start capturing server events, first of all, you need to connect to a server, apply trace templates (if necessary), as well as configure trace file and session data storage settings.
Set events to capture: After you set the required event sources, you can specify the events to be captured using a convenient wizard.
Set actions to capture: Your next step is to specify the actions to be captured in the current event session.
Filter events to capture: Whenever you create a trace, you can apply filters that will help you reduce the output of the tracing data for the required event.