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
• Debug T-SQL code and stored procedures
• Perform stress testing
• Perform quality assurance testing