Tracing multiple servers at once
Profiler can run on any machine and it is able to monitor multiple SQL Server instances simultaneously.
It creates, starts and stops traces at scheduled intervals, it automatically collects tracing data and stores in a central repository.
Built-in and user-defined events
Profiler comes out-of-the-box with a set of built-in tracing events, which have been defined on top of the SQL Server lower level, basic events.
You can always create your own events, specify the data that should be collected by these events or add filters on top of the existing ones.
Powerful filtering and precise tracing
One of the biggest advantages of the Profiler is its powerful filtering capabilities.
Simple criteria, such as equal or like operators, or complex regular expressions are fully supported, providing very precise tracing and minimizing the burden on the participating SQL Servers.
Just the data you want, no more, no less.
Profiler includes a powerful scheduling functionality that allows you to define the time intervals during which traces should run.
You can choose one-time recurring schedules.
You can filter tracing data based on the event type, source SQL Server and database, user, date/time and other criteria.
You can also group the tracing data based on any column. Last but not least, you can query directly the Profiler database.
Performance, auditing and compliance tool
The flexibility of the Profiler makes it an ideal tool for discovering SQL Server performance bottlenecks,
conducting database auditing and compliance with regulations such as Sarbanes-Oxley, HIPAA, GLBA, etc.
Up and running in minutes, no agents to install
Since there are no agents to install on the target SQL Servers, you can be up and running in no time.
It takes just a few minutes to install the Profiler and a few more minutes to configure your traces.
From that point on, Profiler will take care of the rest: starting/stopping traces at the intervals specified by you or saving the tracing data into the central repository.