What is SQL Server Profiler

SQL Server Profiler is Sql Server tool used to perform tracing what is running under the SQL Server Engine’s, and finding out how queries are resolved internally and what scripts are running to accomplish any T-SQL command.

We can trace data like EventClass, TextData, ApplicationName, Duration, SPID, DatabaseName, etc.