concept Profiler in category sql server

appears as: Profiler
Learn Windows SQL Server Administration in a Month of Lunches

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.