dbForge Event Profiler for SQL Server is a FREE tool that allows you to capture and analyze SQL Server events. The events and data columns are stored in a physical trace file for later examination. You can use this information to identify and troubleshoot many SQL Server-related problems.
How Event Profiler can help DBAs
Monitor the activity of the:
SQL Server Database Engine
Analysis Services
Integration Services
Monitor and identify performance-related problems with front-end application, queries, T-SQL, transactions, and much more
Perform query analysis of execution plans
Monitor and identify SQL Server errors and warnings
Audit user activity
Analyze trace results by grouping or aggregating them
Create your own custom traces, and save them, for use whenever you wish
Save trace results to a file
How Event Profiler can help developers
View how SQL Server works when interacting with a client