SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later.

sql profiler captures all activities of server

SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file. We can then analyze or use the trace file to troubleshoot logic or performance problems.