concept Profiler in category sql server
appears as: Profiler

This is an excerpt from Manning's book Learn Windows SQL Server Administration in a Month of Lunches.
In theory, SQL Server Profiler offers a way to track system activity, down to the query level. Profiler is a pretty heavy monitoring solution, meaning it creates its own performance impact and isn’t designed for continual use. It also doesn’t log its data in a way that facilitates using it as an audit log.
Although it’s fine in a lab environment, in production you should avoid running Profiler on the server from which you’re planning to capture traffic. Profiler imposes a lot of overhead, and that can affect your results. Instead, install SQL Server’s management tools on a client computer, and run Profiler there.