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
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
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