SQL Profiler

Is an optional component of Management Studio since SQL Server 2000 version, a graphical user interface to SQL Trace for monitoring an instance of the Database Engine .
Show you Transact-SQL SELECT, INSERT, UPDATE, and DELETE statements. An other error log
https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver15

It’s basically a four steps process:
Step 1: Generate a TRACE/LOAD file for selected database. Open SQL Server Profiler. And click in Play
Step 2: Put the cursor an click button in software ERP or LOAD information in Database
Step 3: Automatically show you the event and the name of table and field
Click in Stop and analyze all the information generate

This book talk about Mastering_Profiler_eBook.pdf spend a weekend reading and practicing, and you’ll have locked down the skills on the most important tool in the Sql toolbox.

Actually is a great tool , but have a significant problem a lot of information to analyze RPC event , TSQL , Security Audit

Actuall is Azure Data Studio to adopt Sql Profiler whit XE Extended Event
https://docs.microsoft.com/en-us/sql/azure-data-studio/sql-server-profiler-extension?view=sql-server-ver15
All the new features in SQL Server like Azure event is tracker by XE Extended Event https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events?redirectedfrom=MSDN&view=sql-server-ver15
This article talk about https://www.sqlshack.com/es/es-este-el-fin-de-sql-profiler/

The advantage XE is lightweight performance monitoring