The SQL Server Profiler extension provides a simple SQL Server tracing solution similar to SSMS Profiler except built using XEvents. SSMS Profiler is very easy to use and has good default values for the most common tracing configurations. The UX is optimized for browsing through events and viewing the associated T-SQL text. The SQL Server Profiler for SQL Operations Studio also assumes good default values for collecting T-SQL execution activities with an easy to use UX.

-Stepping through problem queries to find the cause of the problem.

-Finding and diagnosing slow-running queries.

-Capturing the series of Transact-SQL statements that lead to a problem.

-Monitoring the performance of SQL Server to tune workloads.

-Correlating performance counters to diagnose problems.

To learn more about Profiler and extended events, [check our documentation.](https://docs.microsoft.com/sql/relational-databases/extended-events/extended-events?view=sql-server-2017)