What is SQL Profiler?

SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance ofMicrosoft SQL Server. You can capture and save data about each event to a file or SQL Server table toanalyze later. For example, you can monitor a production environment to see which stored procedures are hampering performance by executing too slowly.