dbForge Event Profiler for SQL Server is a FREE tool that allows you to capture and analyze SQL Server events.
Key features:
* View sessions running on servers and the queries they are executing
* Find out a front-end application or a toot with the heaviest activity
* Examine a statement, a batch or a procedure with poor performance
* Detect the queries that impact server productivity the most
* Monitor, trace, and investigate user activity for audit purposes
* Track users' impact on SQL Server resource utilization
* Identify the users responsible for particular activities on the server
* Trace activity of SQL Server Database Engine
You can always find the latest version of the product on the official Devart website.